ORA-12992: cannot drop parent key column

Cause : A nattepmtw a smdaet od rpo apraetn ekyc oulm.n

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

Dorpa l lcnosrtanit srfeeernicn gteh aprnetk e yclounm,o rs pceiyf ACSACD ECNOSRTANIT Si nsattmeetn.

update : 24-07-2017
ORA-12992

ORA-12992 - cannot drop parent key column
ORA-12992 - cannot drop parent key column

  • ora-06761 : TLI Driver: error sending orderly release
  • ora-09789 : sllfsk: unable to read file.
  • ora-25276 : table specified is not a queue table
  • ora-01307 : no LogMiner session is currently active
  • ora-34361 : (MXDSS12) number other user reading
  • ora-33269 : while operating on 'string'
  • ora-24393 : invalid mode for creating connection pool
  • ora-14178 : STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes
  • ora-32319 : Cannot use direct loader log to FAST REFRESH materialized view "string"."string"
  • ora-13447 : GeoRaster metadata BRS error
  • ora-02157 : no options specified for ALTER USER
  • ora-01172 : recovery of thread string stuck at block string of file string
  • ora-16084 : an apply engine is already running
  • ora-22870 : ALTER TYPE with REPLACE option a non-object type
  • ora-10658 : Lob column to be shrunk is marked unused
  • ora-12323 : unable to open database (link name string)
  • ora-16203 : Unable to interpret skip procedure return values
  • ora-16526 : unable to allocate task element
  • ora-01984 : invalid auditing option for procedures/packages/functions
  • ora-02456 : The HASH IS column specification must be NUMBER(*,0)
  • ora-15183 : ASMLIB initialization error [string]
  • ora-00724 : ALTER DATABASE CONVERT command has been de-supported
  • ora-13052 : unsupported geometric type for geometry string.string
  • ora-07504 : scgcmn: $hiber unexpected return
  • ora-27484 : Argument names are not supported for jobs without a program.
  • ora-31534 : Change Data Capture string publisher string is missing DBA role
  • ora-37106 : (XSVPART06) Invalid partition name number.
  • ora-07415 : slpath: allocation of memory buffer failed.
  • ora-38460 : filtering based on datatype "string" not supported for XML Tags
  • ora-24386 : statement/server handle is in use when being freed
  • 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.