ORA-20000: Oracle Text error
I have Oracle R11, and I would like create index on table CLOB_EXAMPLE.
CREATE INDEX TESTTMP.I1_CLOB_EXAMPLE ON TESTTMP.CLOB_EXAMPLE(VSEBINA) INDEXTYPE IS CTXSYS.CONTEXT NOPARALLEL
Error at line 1
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drekmap (lob write)
DRG-50858: OCI error: OCI_INVALID_HANDLE
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366
Please help in createing an index
Regards!
Hine
-------------------------------------------------------------------------------------------
CREATE TABLE TESTTMP.CLOB_EXAMPLE
(
VSEBINAID NUMBER NOT NULL,
MAPAID NUMBER NOT NULL,
VSEBINAPRIKAZID NUMBER NOT NULL,
VRSTAID NUMBER NOT NULL,