ORA-22869: depth of type dependency hierarchy exceeds maximum limit

Cause : The type dependency hierarchy was structured to have depth greater than 1024.

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

Re-structure the type dependency hierarchy to a shorter depth.

update : 23-09-2017
ORA-22869

ORA-22869 - depth of type dependency hierarchy exceeds maximum limit
ORA-22869 - depth of type dependency hierarchy exceeds maximum limit

  • ora-16070 : parameter string contains an invalid REGISTER attribute value
  • ora-31463 : logfile location string is an empty directory
  • ora-03219 : Tablespace 'string' is dictionary-managed, offline or temporary
  • ora-02447 : cannot defer a constraint that is not deferrable
  • ora-24123 : feature string is not yet implemented
  • ora-28273 : No mapping for user nickname to LDAP distinguished name exists.
  • ora-31625 : Schema string is needed to import this object, but is unaccessible
  • ora-38862 : FLASHBACK DATABASE in progress
  • ora-10262 : Don't check for memory leaks
  • ora-30568 : cannot drop log group - nonexistent log group
  • ora-07246 : sfofi: open error, unable to open database file.
  • ora-07759 : slemtr: invalid destination
  • ora-31016 : Attempted to delete entry without name
  • ora-24036 : invalid SORT_ORDER column string specified for queue table
  • ora-00071 : process number must be between 1 and string
  • ora-26530 : unable to build materialized view refresh control list
  • ora-16731 : error executing dbms_logstdby.unskip_txn procedure
  • ora-13194 : failed to decode supercell
  • ora-30114 : error when processing from command line
  • ora-22620 : buffer size too small to hold the value
  • ora-06703 : TLI Driver: send break message failed
  • ora-07475 : slsget: cannot get vm statistics.
  • ora-29507 : query derived from USING clause found zero or many rows
  • ora-16234 : restarting to reset Logical Standby apply
  • ora-31600 : invalid input value string for parameter string in function string
  • ora-16579 : bad Data Guard NetSlave state detected
  • ora-29917 : cannot lock a table which gets its rows from a collection operand
  • ora-29300 : ORACLE error, tablespace point-in-time recovery
  • ora-13430 : the GeoRaster object has null attribute(s)
  • ora-22807 : cannot resolve to a scalar type or a collection type
  • 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.