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 : 25-04-2017

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

  • ora-29816 : object being disassociated is not present
  • ora-29266 : end-of-body reached
  • ora-16782 : instance not open for read and write access
  • ora-02734 : osnftt: cannot reset shared memory permission
  • ora-14062 : one or more of table's partitions reside in a read-only tablespace
  • ora-24785 : Cannot resume a non-migratable transaction
  • ora-38432 : EVALUATE operator only allowed on an expression column
  • ora-29956 : warning in the execution of ODCIINDEXEXCHANGEPARTITION routine
  • ora-31422 : owner schema string does not exist
  • ora-12548 : TNS:incomplete read or write
  • ora-31636 : session is already attached to job string for user string
  • ora-02089 : COMMIT is not allowed in a subordinate session
  • ora-25302 : Operation not possible for non-buffered queue string
  • ora-16070 : parameter string contains an invalid REGISTER attribute value
  • ora-31447 : cannot create change tables in the SYS schema
  • ora-31532 : cannot enable change source string
  • ora-13337 : failure in concatenating LRS polygons
  • ora-08315 : sllfrb: Error reading file
  • ora-14009 : partition bound may not be specified for a LOCAL index partition
  • ora-29375 : sum of values string for level string, plan string exceeds string
  • ora-12675 : External user name not available yet
  • ora-12471 : Specified compartment or group is not authorized for user
  • ora-02433 : cannot disable primary key - primary key not defined for table
  • ora-01145 : offline immediate disallowed unless media recovery enabled
  • ora-25190 : an index-organized table maintenance operation may not be combined with other operations
  • ora-16540 : invalid argument
  • ora-25001 : cannot create this trigger type on views
  • ora-23443 : missing template parameter
  • ora-30576 : ConText Option dictionary loading error
  • ora-02273 : this unique/primary key is referenced by some foreign keys
  • 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.