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.
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
Previous Topic: Re: Help requested - context cartridge
Next Topic: PDF indexing problem
Goto Forum:
  


Current Time: Thu Mar 28 09:16:12 CDT 2024