SQL*Plus (MOSC)

MOSC Banner

ORA-20000: Oracle Text error

edited Jul 24, 2012 6:19PM in SQL*Plus (MOSC) 2 commentsAnswered
Dear

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center