-
Index creation error
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|