Re: how to activate oracle text in 10g enterprise

From: hpuxrac <>
Date: Tue, 9 Dec 2008 05:28:48 -0800 (PST)
Message-ID: <>

On Dec 9, 2:23 am, "stc" <> wrote:


> >I made the entirely reasonable extrapolation that someone who was
> >unfamiliar with Oracle would choose to either (a) let the universal
> >installer perform the db configuration, (b) use DBCA to install a
> >general purpose database, or (c) if he wanted to study otext, and was
> >brave enough to choose a custom database, he would not deselect the
> >'Oracle Text' option from the DBCA screen.
> >So while I agree that "We don't all use the pre-cooked databases, or
> >use DBCA and accept everything", I'll bet you OP did.
> The only reason I chose custom database during the installation was because
> of the fact I needed to use Unicode character set and not the default
> (Win1250 if I remember correctly). I don't recall changing any other options
> especially not *deselecting* Oracle Text option. Maybe it needed to be
> *selected* and I overlooked it.

Maybe you just don't have enough caffeine in the system when making some of the replies here.

If you experienced oracle warnings and errors during the install ( from the admin script ) such as the ones you posted ... it means that it was already installed.

Why don't you check out idevelopment and look at Jeffrey Hunters examples of text searching if you aren't motivated enough to actually read the real oracle doc?

Alternatively post the complete test case that you are working on that you are convinced doesn't work or doesn't work fast enough including the scripts ... outputs ... explain plans or 10046 trace output put thru something like orasrp etc ... Received on Tue Dec 09 2008 - 07:28:48 CST

Original text of this message