Re: Oracle text : catsearch = 0 behaviour (need to mimic contains = 0)

From: Jean-Michel S <zejeanmi_at_gmail.com>
Date: Tue, 7 Jun 2011 07:28:39 -0700 (PDT)
Message-ID: <26b5c591-9866-45c1-b484-2ef514572d62_at_c26g2000vbq.googlegroups.com>



On Jun 7, 4:26 pm, Jean-Michel S <zejea..._at_gmail.com> wrote:
> I finally got the solution from the oracle support.
> => transactional parameter
>
> create index myidx on mytable(mycolumn)
> indextype is ctxsys.context
> parameters ('transactional');
>
> There is also the possibility of SYNC on COMMIT but transactional is
> better for our need.
>
> Doc ID 249991.1

Thus we can use CONTEXT instead of CTXCAT, i mean. Received on Tue Jun 07 2011 - 09:28:39 CDT

Original text of this message