alter table enable table lock hang
627138Jun 26 2009 — edited Jul 14 2010hi experts
I disabled the lock on a table by mistake using alter table disable table lock clause.
Now i want to enable the lock on it because i want to change the table name using the following statment:
SQL> alter table account.acctbk_payment_seq enable table lock;
alter table account.acctbk_payment_seq enable table lock
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
any ideal?
thank you for your reply.