ORA-36991: (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.

Cause : There si a conlfict bewteen th ehierarhcy/leve lrelatino and teh levelo rder vlaueset.

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

Chooseo bjectst hat don ot conlfict.

update : 23-09-2017
ORA-36991

ORA-36991 - (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.
ORA-36991 - (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.

  • ora-26076 : cannot set or reset value after direct path structure is allocated
  • ora-06954 : Illegal file name
  • ora-32304 : materialized views with user-defined types cannot use prebuilt table
  • ora-01016 : This function can be called only after a fetch
  • ora-32034 : unsupported use of WITH clause
  • ora-01317 : Not attached to a Logminer session
  • ora-02420 : missing schema authorization clause
  • ora-01303 : subordinate process error: number. Check alert and trace logs
  • ora-07607 : szaud: $SNDOPR failure
  • ora-29534 : referenced object string.string could not be resolved
  • ora-38404 : schema extension not allowed for the attribute set name
  • ora-30445 : workload queries not found
  • ora-01308 : initialization parameter utl_file_dir is not set
  • ora-07200 : slsid: oracle_sid not set.
  • ora-38726 : Flashback database logging is not on.
  • ora-30355 : materialized view container does not exist
  • ora-25177 : UNRECOVERABLE option not permitted
  • ora-09806 : Allocation of label string buffer failed.
  • ora-23494 : too many rows for destination "string"
  • ora-22894 : cannot add constraint on existing unscoped REF columns of non-empty tables
  • ora-01692 : unable to extend lob segment string.string partition string by string in tablespace string
  • ora-37112 : OLAP API requires Oracle 9.2 or later
  • ora-01086 : savepoint 'string' never established
  • ora-15097 : cannot SHUTDOWN ASM instance with connected RDBMS instance
  • ora-12597 : TNS:connect descriptor already in use
  • ora-25130 : cannot modify primary key - primary key not defined for table
  • ora-01104 : number of control files (string) does not equal string
  • ora-32321 : REFRESH FAST of "string"."string" unsupported after detail table TRUNCATE
  • ora-14301 : table-level attributes must be specified before partition-level attributes
  • ora-22298 : length of directory alias name or file name too long
  • 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.