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:26:18 -0700 (PDT)
Message-ID: <c59238e4-b72c-4a52-b623-fb96bc1c6ee2_at_u19g2000vbi.googlegroups.com>
I finally got the solution from the oracle support.
=> transactional parameter
Date: Tue, 7 Jun 2011 07:26:18 -0700 (PDT)
Message-ID: <c59238e4-b72c-4a52-b623-fb96bc1c6ee2_at_u19g2000vbi.googlegroups.com>
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 Received on Tue Jun 07 2011 - 09:26:18 CDT