Re: how to activate oracle text in 10g enterprise
Date: Sun, 7 Dec 2008 09:35:37 +0100
Message-ID: <ghg1ta$bst$1@ss408.t-com.hr>
"Palooka" <nobody_at_nowhere.com> wrote in message
news:jwB_k.7731$Wq1.6696_at_newsfe18.ams2...
> BicycleRepairman wrote:
>>
>> In 10g, Oracle Text is a component of the db. You can't not have it,
>> and there is nothing to install.
> Completely incorrect. As Steve Howard mentions, catctx.sql installs it.
> Incidentally, catnoctx.sql removes it.
>
> Palooka
I followed the instructions from
http://download.oracle.com/docs/cd/B19306_01/install.102/e10319/initmedia.htm#DFSIG270
and executed the script. Although I've seen few errors displayed on the
screen, they were scrolled out of the screen pretty fast and I'm not sure
how serious they were. There was nothing in catctx.log.
After that I created preference, set attribute and created index (of ctxsys.context indextype) but the execution time of the query is now 160-180 seconds?!?!? As compared to the same query using LIKE operator which lasts 8 seconds. Received on Sun Dec 07 2008 - 02:35:37 CST