> It may be possible to still have it work by doing a speculative record
> in the index for the target table then go and check all of the other
> indexes before marking the speculative entry as valid.
It is always valid - except in the OVERRIDING SYSTEM VALUE case - no?
False.
ALTER TABLE … ALTER id RESTART 1;
David J.
