|DDL With the WAIT Option (DDL_LOCK_TIMEOUT) - Avoid unnecessary ORA-00054: resource busy errors in 11g.|
Raja said...I have tried out the same in 220.127.116.11. But the ALTER TABLE does not wait for the mentioned seconds but throws error immediately. However, when I try with DROP TABLE, it works. Can you pls. clarify why is it so ?
Alex Bloom said...WARNING: it doesn't work in 11g (18.104.22.168) if compatibility parameter is set to 22.214.171.124.
DDL statement doesn't even error out with ORA-00054, but instead it just hangs indefinitely waiting for DML to complete. DDL_LOCK_TIMEOUT parameter is completely ignored.