Re: how to activate oracle text in 10g enterprise

On Dec 9, 2:23 am, "stc" <slowtraincom...@xxxxxxxxxxxx> wrote:

snip

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 ...
.

Relevant Pages

  • Re: AIX 4.3.3 , Oracle 7.3.4 coredumps at startup
    ... I cannot port the database to Oracle 8 or later since the app ... > the apps that are now reserved words in Oracle 8 and later. ... Put away your installation media and forget a new install for the moment. ...
    (comp.unix.aix)
  • Re: Unable to manually create RAC database
    ... some assistance with this as my RAC experience is very limited. ... I have managed to manually create a single instance database (on ... With the Partitioning, Real Application Clusters, OLAP and Oracle Data ... can get with a manual install. ...
    (comp.databases.oracle.server)
  • Re: Adding RAM
    ... About Oracle, I currently use Mysql for my TM databases but I have been ... Limited to a 4GB database but that should be adequate ... The rpm is easy to install and you get a nice tutorial to ... Here's the link to the Oracle-10g + Compiere installation on SuSE ...
    (alt.os.linux.suse)
  • Re: dbca not working in Linux
    ... > And now the database configuration assistant doesn't work ... > This was run as the oracle user. ... Next, when you start the install, you will get an error message (something ...
    (comp.os.linux.setup)
  • Re: dbca not working in Linux
    ... > And now the database configuration assistant doesn't work ... > This was run as the oracle user. ... Next, when you start the install, you will get an error message (something ...
    (alt.os.linux.suse)