Remove rows not needed from ctxsys.dr$Pending
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