Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error creating text index

198863Nov 26 2002

I try to create text index for table Profiles with column CLOB data type with errors described below.
How to get rid of this? Any help appreciated. Thank you in advance.

create index indProfilesProf on Profiles(Profile) indextype is ctxsys.context;

create index indProfilesProf on Profiles(Profile) indextype is ctxsys.context

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10516: failed to perform DDL operation due to an Oracle error
DRG-50857: oracle error in driddl.PolicyCreate
ORA-00001: unique constraint (CTXSYS.DRC$IDX_COLSPEC) violated
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 176

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 30 2002

Added on Nov 26 2002

#database-key-features, #text

3 comments

969 views