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: ConText Option indexing error

Re: ConText Option indexing error

From: <Kevin.loney_at_astramerck.com>
Date: 1997/06/03
Message-ID: <865364691.1943@dejanews.com>#1/1

In article <5n0vrt$fjf_at_news.Informatik.Uni-Oldenburg.DE>,   Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de wrote:
>
> Hi,
>
> when I try to create a ConText index I alwys get an error:
>
> SQL> execute ctx_ddl.create_index('ctx_soif_keys')
> begin ctx_ddl.create_index('ctx_soif_keys'); end;
>
> *
> ERROR at line 1:
> ORA-20000: ConText error:
> ORA-06512: at "CTXSYS.DRUE", line 110
> ORA-06512: at "CTXSYS.CTX_DDL", line 245
> ORA-06512: at line 1
>
> The policy 'ctx_soif_keys' was successfully created...
>
> What am I doing wrong?
>

Gerhard,

The most likely cause of this problem is that you are missing a ConText DDL server. Go into CTXCTL and run the STATUS command. You wouldn't get that error when creating a policy because a policy executes DML, not DDL. btw, this will be covered in an upcoming Oracle Press book.

Kevin Loney.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Tue Jun 03 1997 - 00:00:00 CDT

Original text of this message

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