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

NNL-00873: Fastest update processing time: string

1 Answers  


RMAN-06062: can not backup SPFILE because the instance was not started with SPFILE

1 Answers  


ORA-13635: The value string provided for parameter string cannot be converted to a number.

1 Answers  


ORA-06742: TLI Driver: cannot alloc t_bind

1 Answers  


ORA-10571: Test recovery canceled

1 Answers  






PLS-00248: Invalid Library Syntax

1 Answers  


ORA-16595: NetSlave process string failed to terminate

1 Answers  


LFI-01501: tmpnam() fails to generate temporary file name.

1 Answers  


ORA-02095: specified initialization parameter cannot be modified

1 Answers  


ORA-02238: filename lists have different numbers of files

1 Answers  


ORA-01611: thread number string is invalid - must be between 1 and string

1 Answers  


ORA-21702: object is not instantiated or has been de-instantiated in cache

1 Answers  


Categories