cannot acquire lock -- table locks disabled
551752Aug 9 2007 — edited Aug 9 2007Hi all,
I created a test table but not able to drop it DB version is 10.2.0
SQL>create table abcd(xyz number);
Table created.
SQL>alter table abcd disable table lock;
Table altered.
SQL>drop table abcd;
drop table abcd
*
ERROR at line 1:
ORA-00069: cannot acquire lock -- table locks disabled for ABCD
SQL>alter table abcd enable table lock;
alter table abcd enable table lock
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
reconnected and try to enable the Lock on table, it is giving same error
what may be the reason?
thanks in advance