keep intermedia index up-to-date

From: Martin Koeck <nospam_at_nospam.at>
Date: Wed, 04 Apr 2001 17:47:07 +0200
Message-ID: <3ACB41FB.3C349E75@nospam.at>

we use an intermedia index to index a CLOB column and be able to search it via SELECT ... CONTAINS, which seems to work so far

it seems that rows
- can be inserted/updated but changes are NOT reflected in the index

so what to do to keep the index "automatically" up-to-date ?

something like "alter index ... rebuild" on a trigger does not work because this implies a commit which is not allowed in a trigger

thanks for any comments on this,
martin Received on Wed Apr 04 2001 - 10:47:07 CDT