Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Preventing DDL to wait for other sessions

Hello out there,
in the good old days™ when I issued a DDL commant like

alter table test add (grmpf number(4));

This immediately returned with an ORA-00054 when another session had a DML lock on that table. But now it waits till the other session commits or rolls back.

I did

alter session set ddl_lock_timeout=0;

but that does not help. So how can I prevent the DDL from waiting?

Comments
Post Details
Added 4 days ago
6 comments
100 views