Comments for DDL With the WAIT Option (DDL_LOCK_TIMEOUT)
Raja said...I have tried out the same in 22.214.171.124. 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 (126.96.36.199) if compatibility parameter is set to 188.8.131.52.
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.
Jeff Jacobsa said...DDL Timeout works with MODIFY, but as noted, ADD apparently already waits forever. DDL_TIMEOUT has no effect on adding columns.
Yes. The example was bad. I switched it to MODIFY and actually included the output from the command, which is a little better.
DO NOT ask technical questions here! They will be deleted!
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!