Comments
| 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 11.1.0.6. 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 (11.2.0.3) if compatibility parameter is set to 11.2.0.0.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. |
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!