nowait.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 13 行

ORA-00054 resource busy and acquire with NOWAIT specified

Cause: The NOWAIT keyword forced a return to 
the command prompt because a resource was unavailable for 
a LOCK TABLE or SELECT FOR UPDATE command.

Action: Try the command after a few minutes or 
enter the command without the NOWAIT keyword.
使用NOWAIT将立刻返回一个错误信息，控制权回到用户。
不用NOWAIT，则LOCK住，控制权不会用户直到其它SESSION  COMMIT!