1 Reply Latest reply: Mar 14, 2013 3:12 PM by Ebalthes-Oracle RSS

    TEXTINDEX DR$PENDING

    user8684352
      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
        • 1. Re: TEXTINDEX DR$PENDING
          Ebalthes-Oracle
          If your query:

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

          does NOT return any existing indexes: "select IDX_ID, IDX_NAME from ctxsys.dr$index where IDX_ID=1851" then try and call ctx_ddl.sync_index a few times.
          If ctx_ddl.sync_index does not clean these pending rows then its safe to manually delete them. Make sure ctxsys,dr$waiting has also no orphan rows for this index with ID=1851.

          The best practice would be to implement on a release where you could get full error correction support, e.g. 11.2.0.3 or 10.2.0.5