hi all,

Software: oracle 9i (9.2) windows.

when i try to create a index for my file storage (Text Search) it gives following error.

SQL> begin
2 ctx_ddl.create_preference('myFILE','FILE_DATASTORE');
3 ctx_ddl.set_attribute('myFILE','PATH','c:\test');
4 end;
5 /

PL/SQL procedure successfully completed.

SQL>
SQL> create index DS_FileSveidx on Mydocs(MydocsName)
2 indextype is ctxsys.context
3 parameters ('Datastore myFILE')
4 /
create index DS_FileSveidx on Mydocs ( MydocsName )
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 186

Table Structire:
MydocsName NOT NULL VARCHAR2(300)
DocID NOT NULL NUMBER(10)
MyREMARK VARCHAR2(300)


What could be the reason, please help.

The user logged-in is with DBA rights.

thanx.
sam