Re: Context Cartridge

I will make some assumptions about the versions of Context and database you are using. If you have completed a correct setup of Context you should certainly have the CTXADMIN and CTXUSER roles available. If you do not I would suggest dropping the CTXSYS user and start again, ensuring you complete the following steps:

run the drcrsyst.sql sript

run the dr0inst.sql script

import the ctxset.dmp file?

set TEXT_ENABLE = TRUE in your initsid.ora

The three roles CTXADMIN, CTXAPP and CTXUSER will exist if you have done everything properly (assuming you aren't actually using Intermedia Text against 8i). If they don't exist, you are missing something in your setup.

Sorry, I know this isn't much help, but it is the best I could do without more detail.

Rod J. Stewart

Niels Voorhoeve <nvoorhoeve_at_ftpoint.com> wrote in message news:7rekej$a91$1_at_brinkley.rutgers.edu...
> Hi,
>
> We installed Oracle with the context cartridge, and can create indexes,
but
> the contains(column,'whatever')>0 queries return no rows. The indexes
> were created in same session prior to running the queries.
> I set text_enable = false with alter session (it is set true in the
instance
> init file) in order to get the queries not to give errors (but also not
> return rows). But when text_enable is set true in the session I get the
> following error:
>
> RA-00604: error occurred at recursive SQL level 1
> ORA-06550: line 1, column 7:
> PLS-00201: identifier 'CTXSYS.DR_REWRITE' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> Apparently, permissions is an issue here. I found that the CTXADMIN and
> CTXUSER roles do not exist, when I try to assign them. What's going on
> here?
>
>
>
> -Niels
>
>
Received on Sun Sep 12 1999 - 22:32:08 CDT