Home » Server Options » Text & interMedia » Error on create index ... index type is ctxsys.context
Error on create index ... index type is ctxsys.context [message #75962] Wed, 03 July 2002 03:55 Go to next message
Laure
Messages: 1
Registered: July 2002
Junior Member
Hello,

I want to create a context index on a CLOB column :

CREATE INDEX IT_SEARCH_URL ON SEARCH(TEXT) INDEXTYPE IS CTXSYS.CONTEXT;

The error below is appeared :

ERREUR à la ligne 1 :
ORA-04045: errors during recompilation/revalidation of CTXSYS.CONTEXT
ORA-29835: ODCIGETINTERFACES routine does not return required interface(s)

Please, I need help.

Report message to a moderator

Re: Error on create index ... index type is ctxsys.context [message #75963 is a reply to message #75962] Wed, 10 July 2002 06:10 Go to previous message
darondeau eric
Messages: 1
Registered: July 2002
Junior Member
Il semblerait que des objets appartenent à CTXSYS (voir ORDSYS) aient un staus INVALID (suite à une manip qqc).

Vérifie le par la requête SELECT OBJECT_NAME, OBJECT_TYPE from ALL_OBJECTS where OWNER IN ('ORDSYS',CTXSYS') and STATUS = 'INVALID';

Si c'est le cas recompile les

Eric

Report message to a moderator

Previous Topic: Re: Help requested - context cartridge
Next Topic: PDF indexing problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 22 19:40:22 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.