Check on MetaLink note: 147362.1;
also extproc might have been deleted (see Security Alert 29)
inka
-----Original Message-----
Sent: Thursday, September 12, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L
Hello All;
I am being plagued with an error I can't get my hands around when I try to
recreate a context index. The index existed previously, but when I tried to
sync new data I got an error, then I attempted rebuilding the index from
scratch and got the same error (see below). I checked the $ORACLE_HOME/lib
directory and found the library that the error indicates as missing.
Any help would be greatly appreciated!
sql statements executed:
call Ctx_Ddl.Drop_stoplist ('my_stoplist')
/
call Ctx_Ddl.create_stoplist('my_stoplist')
/
drop index TFNR_DISPLAY_NAME_IDX_C
/
create index TFNR_DISPLAY_NAME_IDX_C on TFNR (Display_Name)
indextype is ctxsys.context
parameters ('stoplist my_stoplist')
/
error returned:
Call completed.
Call completed.
drop index TFNR_DISPLAY_NAME_IDX_C
*
ERROR at line 1:
ORA-01418: specified index does not exist
create index TFNR_DISPLAY_NAME_IDX_C on TFNR (Display_Name)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: ConText error:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: ld.so.1: extprocPLSExtProc: fatal: libskgxp8.so: open failed: No
such file or directory
ORA-06512: at "CTXSYS.DRUE", line 122
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34
ORA-06512: at line 1
Sebastian DiFelice
DBA/Database Analyst
Thomson
Intelligence Data
(617)856-1587
www.intelligencedata.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DiFelice, Sebastian
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Inka Bezdziecka
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
