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

0 0

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>

About Post Author

Jurgen Kemmelings

Oracle consultant at AMIS

Jurgen.Kemmelings@amis.nl

Happy

0 0 %

Sad

0 0 %

Excited

0 0 %

Sleepy

0 0 %

Angry

0 0 %

Surprise

0 0 %

Related posts:

Use Data Tree in List of Values Window – ADF BC and UIX and JHeadstart Introducing Spring Framework – Overview presentation and demonstration for Oracle Consulting Death of the End Date – How LAG and LEAD help fight redundancy Submit an Abstract for the ODTUG 2006 Virtual Desktop Conference (deadline 15th November) KC SDPL – Jonathan Lewis