DDL Wait Option in Oracle.
DDL Wait Option in Oracle. A DBA is trying to alter the table called SALES to add a column, TAX_CODE. he issues the following SQL statement:
|
1 |
SQL> alter table sales add (tax_code varchar2 (10)); |
But instead of getting something like “Table altered”, he gets:
|
1 2 3 4 |
SQL>>Alter table sales add (tax_code varchar2 (10)) * ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired |
The error message says it all: the… Read More
