ORA-34001: (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension.

Cause : Eihtert woc onact idmesniosn wihchs haer ac omomn elafd imnesino, ro ac onact nad noe fo ist laeve swhree obths peicfide i nth eDIEMNSOIN tsatmeen(ts).

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

Don ots peicfyo velrapipngc onact idmesniosn, ro ayn laeve sofs peicfide cnoca tdiemnsoins.

update : 24-04-2017
ORA-34001

ORA-34001 - (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension.
ORA-34001 - (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension.

  • ora-02277 : invalid sequence name
  • ora-14155 : missing PARTITION or SUBPARTITION keyword
  • ora-25226 : dequeue failed, queue string.string is not enabled for dequeue
  • ora-21706 : duration does not exist or is invalid
  • ora-37003 : (AWLISTALL01) number readers
  • ora-38773 : cannot add data file 'string' - file already part of database
  • ora-39082 : Object type string created with compilation warnings
  • ora-15166 : cluster in rolling downgrade from version [string] to [string]
  • ora-27369 : job of type EXECUTABLE failed with exit code: string
  • ora-12537 : TNS:connection closed
  • ora-19591 : backup aborted because job time exceeded duration time
  • ora-01890 : NLS error detected
  • ora-12456 : label security startup in progress
  • ora-38447 : Type required for the embedded ADT attribute "string" is missing
  • ora-22890 : cannot specify name for REF column constraint
  • ora-02189 : ON required
  • ora-13799 : threshold not found
  • ora-29325 : SET COMPATIBILITY release number lower than string
  • ora-09983 : skxfidsht: Error shutting down SDI channel
  • ora-37154 : OLAP API initialization error: (case string)
  • ora-13612 : The recommendation action string,string is not valid for task string.
  • ora-01680 : unable to extend LOB segment by string in tablespace string
  • ora-39020 : invalid mode type string
  • ora-06816 : TLI Driver: could not set the SPX SAP address
  • ora-25210 : invalid value for RELATIVE_MSGID, no message in queue with that msgid
  • ora-24182 : attribute number specified does not exist
  • ora-30475 : feature not enabled: string
  • ora-23402 : refresh was aborted because of conflicts caused by deferred txns
  • ora-09876 : TASDEF_CLOSE: unable to close ?/dbs/tasdef@.dbf file.
  • ora-30739 : cannot drop a table that has subtables
  • 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.