Hi All,

II 10.0.0 (a64.lnx/132)NPTL + p13998

I have a table with many constraints, two of which share an index. One is aforeign key constraint and the other is a uniqueness constraint.

I needed to add an extra column to the unique set.

Trouble is that I forgot to include 'set trace point qe61' and so the firstalter table drop constraint also dropped the supporting index. The subsequent alter table drop constraint the failed with E_US16D5 Table specified nolonger exists. Sadly the job then committed and quit.

Fortunatly it was run on a test version of the live database!

Now I can't heal the problem on the test database.
I can recreate the index and the constraint and seemingly get things back to what they should be, but rerunning the corrected script still fails with E_US16D5. BTW. The corrected script works fine when run fresh on another copy of the live database and on the live database itself.

I'm thinking that somewhere in the bowels of the constraint definition it saved the reltid, reltidx of the original index and this of course won't match the new index. I've just looked through iiconstraint and can't see any obvious magic there.

Anyone got any idea?

Martin Bowes