Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: errors, need some help

Re: errors, need some help

From: Fabrizio <fabrizio.magni_at_mycontinent.com>
Date: Mon, 18 Jul 2005 18:12:56 GMT
Message-ID: <IiSCe.175786$75.7634137@news4.tin.it>


jimi_xyz_at_hotmail.com wrote:
> hello,
> Im starting to just get into oracle text, and I seem to be getting a
> error when i index my table...
>
> SQL> create index idxmytable
> 2 on mytable(doc2search)
> 3 indextype is ctxsys.context
> 4 parameters('sync(on commit)');
> create index idxmytable
> *
> ERROR at line 1:
> ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
> ORA-20000: Oracle Text error:
> DRG-11000: invalid keyword SYNC(ON
> ORA-06512: at "CTXSYS.DRUE", line 157
> ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 219
>
> Im not asking for someone to figure out the problem for me, just set me
> out on the path. Please no wise @ss remarks either.
>
> Thank you,
> Jimmie
>

Check the network configuration: listener in particular (is it running and listening on the right port?) and the LD_LIBRARY_PATH variable.

Regards

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe
Received on Mon Jul 18 2005 - 13:12:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US