Oracle Text (MOSC)

MOSC Banner

Remove rows not needed from ctxsys.dr$Pending

edited Oct 27, 2015 10:05AM in Oracle Text (MOSC) 3 commentsAnswered

We do a nightly sync of attachments stored on our datastore with the Oracle Text Index.

Now we are finding some of these files are getting really large now and we want to restrict what Oracle does index on

Is it as simple as running each night before the sync takes place something like?

delete from ctxsys.dr$Pending

where pnd_rowid in

(select rowid FROM TBLattachments

where  size > 100000000)

size in bytes being > 100m
and tblattachments is where we provide the link to the path on our datastore

ta

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center