Home » Server Options » Text & interMedia » Oracle Text error:deadlock detected while waiting for resource
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?

 
Previous Topic: CLOB insert problem in Oracle Text
Next Topic: Forms 6 and Intermedia
Goto Forum:
  


Current Time: Thu Mar 28 07:32:58 CDT 2024