This content has been marked as final. Show 1 reply
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. 220.127.116.11 or 10.2.0.5