ORA-37043: (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.

Cause : Someo bjec trequried lcokinga comopsite ,concta, diemnsio nmap,o r inetrnalp artiiton i nthe rpesen tgeneartion ,whic his nto posisble isnce anewe rgeneartiona lreayd exitss.

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

Try ot acqiure teh mai nobjetc wit hresycn

update : 24-08-2017
ORA-37043

ORA-37043 - (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.
ORA-37043 - (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.

  • ora-33315 : (XSDELDENTANON) You cannot delete workspace object while looping over unnamed composite workspace object.
  • ora-30162 : The OCIFile context is not initialzed
  • ora-02797 : No requests available
  • ora-38756 : Flashback is already turned off for this tablespace.
  • ora-13204 : failed to create spatial index table
  • ora-13861 : Statistics aggregation for client identifier string is already enabled
  • ora-36669 : (XSDPART07) string is not a legal LIST partition.
  • ora-15067 : command or option incompatible with diskgroup redundancy
  • ora-23500 : cannot switch master for a multi-tier materialized view repgroup "string"."string"
  • ora-29258 : buffer too small
  • ora-17506 : I/O Error Simulation
  • ora-23615 : Block number string does not exist for script string
  • ora-07751 : slemcr: malloc failure
  • ora-16208 : Logical standby dictionary build failed to start.
  • ora-13210 : error inserting data into the index table
  • ora-14451 : unsupported feature with temporary table
  • ora-16026 : parameter string contains an invalid attribute value
  • ora-26695 : error on call to string: return code string
  • ora-15048 : ASM internal files cannot be deleted
  • ora-32816 : foreign queue string is referenced by a subscriber or schedule
  • ora-30501 : instance shutdown triggers cannot have AFTER type
  • ora-30475 : feature not enabled: string
  • ora-16631 : operation requires shutdown of database/instance "string"
  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-32641 : invalid expression in MODEL rule ORDER BY clause
  • ora-36846 : (XSLMGEN16) AW name is greater than 30 bytes
  • ora-01232 : cannot start online backup - file string is being made read-only
  • ora-22861 : invalid user-defined type
  • ora-19853 : error preparing auxiliary instance string (error string)
  • ora-00340 : IO error processing online log string of thread string
  • 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.