ORA-12442: policy column "string" already used by an existing policy

Cause : You rtied ot cretae a oplicyw ith hte saem polciy coulmn nmae asa n exsitingp olic.y

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Use adiffreent anme fro thep olic ycolunm or rdop teh exitsing oplicy.

update : 23-05-2017
ORA-12442

ORA-12442 - policy column "string" already used by an existing policy
ORA-12442 - policy column "string" already used by an existing policy

  • ora-13427 : invalid BLOB parameter for output
  • ora-02149 : Specified partition does not exist
  • ora-01313 : LogMiner dictionary column type different from specified type
  • ora-24181 : The type string does not exist
  • ora-34900 : (PPWKDAYS00) At least 7 day names must be given. Only number were provided.
  • ora-23440 : incorrect public template value
  • ora-23496 : can not change disabled status for "string" and "string"
  • ora-25296 : Queue Table string has a buffered queue string
  • ora-19625 : error identifying file string
  • ora-29266 : end-of-body reached
  • ora-08210 : Requested I/O error
  • ora-29970 : Specified registration id does not exist
  • ora-02150 : invalid new tablespace name
  • ora-14643 : Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-09796 : szrbuild: malloc of role name failed.
  • ora-30977 : invalid Value Index option for XML Index
  • ora-31495 : error in synchronous change table on "string"."string"
  • ora-07261 : spdde: kill error, unable to send signal to process.
  • ora-10635 : Invalid segment or tablespace type
  • ora-16072 : a minimum of one standby database destination is required
  • ora-23358 : invalid remote user
  • ora-16219 : This database is not preparing to switch over.
  • ora-37602 : (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-32608 : missing INCREMENT or DECREMENT keyword in FOR loop
  • ora-37038 : (XSMLTDCL04) You cannot change definitions of objects in analytic workspace string because it is attached in MULTI mode.
  • ora-04054 : database link string does not exist
  • ora-32640 : FOR LIKE loops are not allowed for multi-byte character types
  • ora-09944 : Password entry is corrupt.
  • ora-01870 : the intervals or datetimes are not mutually comparable
  • ora-12463 : undefined group string for policy string
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.