Oracle 9i

[Sirius_Black]

Hiiii everyone I have an oracle problem especially about Oracle Text, here is my problem :)

When I want to create index in my Oracle using indextype ctxsys.context it always appear some messages error :

Here is my PL/SQL formula :

> create or replace directory MY_DIR as 'E:\Project\Tugas Akhir\Jurnal_pdf';

> create table oscar (
      nomer number primary key,
      namadoc varchar2(80),
      dok clob
   );

> DECLARE 
      f_lob BFILE;
      c_lob CLOB;
  
    BEGIN
      INSERT INTO oscar(nomer,namadoc,dok)
      VALUES (1,'coba.txt',EMPTY_CLOB())
      RETURN dok into c_lob;
      
      f_lob := BFILENAME('MY_DIR','coba.txt');
      dbms_lob.fileopen(f_lob,dbms_lob.file_readonly);
      dbms_lob.loadfromfile(c_lob,f_lob,dbms_lob.getlength(f_lob));
      dbms_lob.fileclose(f_lob);
      commit;
    END;

>  create index coba on oscar(dok)
    indextype is ctxsys.context;

When I execute the last formula Oracle displayed some message error :

create index coba on oscar(dok)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drixtab.create_index_tables
ORA-00955: name is already used by an existing object
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 186

Can someone helps me n this is very emergency question thanx 4 all :)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://brie4.cshl.edu/pipermail/gramene/attachments/20040406/faa19ae3/attachment.html>