RE: create text index as transactional

  • From: "Connor McDonald" <mcdonald.connor@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 2 May 2007 22:13:05 +0800

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

--
//www.freelists.org/webpage/oracle-l


Other related posts: