Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: create text index as transactional

RE: create text index as transactional

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Wed, 2 May 2007 22:13:05 +0800
Message-ID: <006301c78cc4$0367c740$0300a8c0@dell600m>

-----Original Message-----

Has anybody ever created their Oracle Text index as transactional?

Such as:

create index myidx on mytable(mycolumn)
indextype is ctxsys.context
parameters ('transactional');


--

(Untested but) I would not be surprised if you get the same kind of index degradation that used to be the result of running ctxsrv...

Cheers
Connor

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 02 2007 - 09:13:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US