ORA-37042: (XSACQUIRE_DEP_DEADLOCK) Cannot wait to acquire
composite, concat, dimension map, or internal partition
workspace object since doing so would cause a deadlock.



ORA-37042: (XSACQUIRE_DEP_DEADLOCK) Cannot wait to acquire composite, concat, dimension map, or int..

Answer / guest

Cause: Some object required locking a composite, concat,
dimension map, or internal partition, which would cause a
deadlock

Action: Release some other object that another user is
waiting for and try to acquire this object again.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31666: Master process string had an unhandled exception.

1 Answers  


ORA-29372: identifier string is too long; it must be less than string characters

1 Answers  


ORA-16737: The log transport service for standby "string" has an error.

1 Answers  


IMG-00910: allocation of basic data structure failed

1 Answers  


TNS-01019: set rawmode ON | OFF: set output mode for services and status commands

1 Answers  






ORA-38455: Expression Filter index should be created by the owner.

1 Answers  


VID-00706: unsupported or corrupted input format

1 Answers  


ORA-17622: failed to deregister the memory with Oracle Disk Manager library

1 Answers  


NZE-29109: Cannot create private key object.

1 Answers  


ORA-19510: failed to set size of string blocks for file "string" (blocksize=string)

1 Answers  


ORA-13518: Invalid database id (string)

1 Answers  


ORA-25330: PL/SQL associative arrays may not be used with AQ array operations

1 Answers  


Categories