ORA-00069 while dropping a table

Problem



LAB65>DROP TABLE AK;
DROP TABLE AK
           *
ERROR at line 1:
ORA-00069: cannot acquire lock -- table locks disabled for AK
 
Solution
  
alter table ak enable table lock;

Table altered.



select OWNER,table_lock from dba_tables  where table_name='AK';

OWNER                                        TABLE_LO
------------------------------              --------
AK                                               ENABLED
DOTSOFT                                     DISABLED
 

Now table will be dropped
 

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post