8i | 9i | 10g | 11g | 12c | 13c | 18c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for DDL With the WAIT Option (DDL_LOCK_TIMEOUT)


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.

Jeff Jacobsa said...

DDL Timeout works with MODIFY, but as noted, ADD apparently already waits forever. DDL_TIMEOUT has no effect on adding columns.

Tim... said...

Hi.

Yes. The example was bad. I switched it to MODIFY and actually included the output from the command, which is a little better.

Cheers

Tim...

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!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.