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!

Indextype CTX.CONTEXT does not exist error?

406596Jan 22 2004 — edited Aug 14 2007

Hi, I try to create an index:

CREATE INDEX pdfindex ON pdf_storage(fileblob)
INDEXTYPE is CTXSYS.CONTEXT;

However, I get:
ERROR at line 2:
ORA-29833: indextype does not exist

Cause: There is no index type by the specified name.

Action: Use public views for the index types to see if an index type by the specified name has been created.

What exactly does this mean? I also tried CTXSYS.CTXCAT and get the same error. We are running 9.2.0.4 on Solaris. Is there an installation option or permissions I need to grant? How come the index types are not known? Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 11 2007

Added on Jan 22 2004

#database-key-features, #text

4 comments

12,420 views