<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hiiii everyone I have an oracle problem
especially about Oracle Text, here is my problem :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>When I want to create index in my Oracle using
indextype <FONT color=#ff0000>ctxsys.context</FONT><FONT color=#000000> it
always appear some messages error :</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Here is my PL/SQL formula :</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>> create or replace directory MY_DIR as
'E:\Project\Tugas Akhir\Jurnal_pdf';</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>> create table oscar (<BR>
nomer number primary key,<BR>
namadoc varchar2(80),<BR> dok
clob<BR> );</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>> DECLARE <BR> f_lob
BFILE;<BR> c_lob CLOB;<BR> <BR>
BEGIN<BR> INSERT INTO
oscar(nomer,namadoc,dok)<BR> VALUES
(1,'coba.txt',EMPTY_CLOB())<BR> RETURN dok into
c_lob;<BR> <BR> f_lob :=
BFILENAME('MY_DIR','coba.txt');<BR>
dbms_lob.fileopen(f_lob,dbms_lob.file_readonly);<BR>
dbms_lob.loadfromfile(c_lob,f_lob,dbms_lob.getlength(f_lob));<BR>
dbms_lob.fileclose(f_lob);<BR>
commit;<BR> END;</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>> create index coba on
oscar(dok)<BR> indextype is ctxsys.context;</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>When I execute the last formula Oracle displayed
some message error :</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>create index coba on oscar(dok)<BR>*<BR>ERROR at
line 1:<BR>ORA-29855: error occurred in the execution of ODCIINDEXCREATE
routine<BR>ORA-20000: Oracle Text error:<BR>DRG-50857: oracle error in
drixtab.create_index_tables<BR><FONT color=#ff0000>ORA-00955: name is already
used by an existing object<BR></FONT>ORA-06512: at "CTXSYS.DRUE", line
157<BR>ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 186</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Can someone helps me n this is very emergency
question thanx 4 all :)</FONT></DIV></BODY></HTML>