Home » Server Options » Text & interMedia » Dead lock while creating intermedia text index
Dead lock while creating intermedia text index [message #48441] Sun, 21 November 2004 20:22
sankaram
Messages: 6
Registered: November 2004
Junior Member
I created the context INDEX AS follows;

BEGIN
ctx_ddl.create_preference('MYSTORAGE','BASIC_STORAGE');
ctx_ddl.set_attribute('MYSTORAGE', 'I_TABLE_CLAUSE','tablespace INDEX_TBS INITRANS 3
MAXTRANS 255 STORAGE (INITIAL 512K NEXT 512K PCTINCREASE 0)');
END;

My TABLE have two COLUMNS

Description VARCHAR2(256)
Long_Description VARCHAR2(2000);

I am creating the INDEX ON the above TABLE:

CREATE INDEX index_name ON TABLE(Long_Description)
INDEXTYPE IS CTXSYS.CONTEXT
parameters('storage MYSTORAGE');

Some times not always, While creating the INDEX I found the following error:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drekmap (lob write)
ORA-00060: deadlock detected while waiting for resource

Can any body suggest what is possible reason.

 

Thanking you for ur early reply,
Sankaram
Previous Topic: XML: where registering user defined attributes?
Next Topic: DBMS JOBS
Goto Forum:
  


Current Time: Thu Mar 28 17:16:38 CDT 2024