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
|
|
|