Oracle Text error:deadlock detected while waiting for resource [message #76082] |
Wed, 04 February 2004 01:20 |
ravi rongali
Messages: 1 Registered: February 2004
|
Junior Member |
|
|
We are facing a strange behavior with Oracle Text indexes. When we trying to create text indexes on columns that have huge data, we are getting following error.
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
ORA-00060: deadlock detected while waiting for resource
And also, we are not getting above error always; sometimes it is coming, sometimes not. Oracle version that we are using is 9.2.0.3.0. Can anybody suggest a solution to avoid above problem?
|
|
|