Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DRG-10582 error during index creation

148281Jul 6 2004
Hi!

I am getting the error below when I try to create a context index. I am using an Oracle 9.2.0.1.0 database on a win2000 professional platform. Oracle returns a column which does not really exist. Can anyone help me? Thanks in advanced.

Erick

SQL> CREATE INDEX "SECDB"."TB_ENTITY_INDEX"
2 ON "SECDB"."TB_ENTITY" ('NAM_ENTY_LONG')
3 INDEXTYPE IS CTXSYS.CONTEXT;
CREATE INDEX "SECDB"."TB_ENTITY_INDEX"
*
?1????????????:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10582: column SYS_NC00011$ does not exist in table TB_ENTITY
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 186

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 3 2004
Added on Jul 6 2004
#database-key-features, #text
0 comments
150 views