EXPERT RESPONSE
When the transaction was cancelled, the work that the
transaction had done up to that point needed to be
rolled back. The longer your transaction ran before
cancelling, the longer it will most likely take to
roll back completely. Until the transaction has rolled
back, a DDL command like ALTER INDEX REBUILD will not
be able to obtain the lock that it needs to complete.
And this type of command won't wait for the lock to be
released either. This is what the ORA-54 error message
is telling you. By the time you get this response,
your long running transaction should have rolled back.
So your ALTER INDEX REBUILD statement should work just
fine.
For More Information
|
