New in Oracle 11g: wait added to lock table syntax

Jurgen Kemmelings

In Oracle 11g you can add a wait clause to the lock table command in which you can specify how many seconds you want to wait to get the lock on the table.

SQL> lock table t in exclusive mode wait 10;
lock table t in exclusive mode wait 10
*ERROR at line 1:ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Elapsed: 00:00:09.95
SQL>
Next Post

New in Oracle 11g: Read Only Tables

Facebook0TwitterLinkedinIn Oracle 11g database it is possible to make a table really read only, also for the owner of that table. Until now a table could only be made read only to other users, by granting only the select privilege to these users. But the owner of the table was […]