Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TEXTINDEX DR$PENDING

user8684352Mar 14 2013 — edited Mar 14 2013

Hi all,
I found 572300 row in table DR$PENDING.
"select distinct PND_CID from ctxsys.dr$pending" gives me amongst others the value "1851" representing 572263 rows.
"select IDX_ID, IDX_NAME from ctxsys.dr$index where IDX_ID in (select PND_CID from ctxsys.dr$pending);" does return some indexes but none with PND_CID=1851;

So these data seem to be left over from a former index no longer in existence.
Is there a way to find out where these data come from (I tried mapping rowids to objects but did not receive a reasonable result)?
Can these entries be delete without problem?
DB-version is 10203.

Any help appreciated.

FJH

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 11 2013

Added on Mar 14 2013

#database-key-features, #text

1 comment

1,507 views