Oracle Database Discussions

Hi All,

I am trying to drop schema but below error is coming

1)bdr_local>drop user HILLS_ISSUE_TRACKER cascade;
drop user HILLS_ISSUE_TRACKER cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00069: cannot acquire lock -- table locks disabled for B_ISSUE_COMMENTS

2)bdr_local>alter table HILLS_ISSUE_TRACKER.B_ISSUE_COMMENTS enable table lock;
alter table HILLS_ISSUE_TRACKER.B_ISSUE_COMMENTS enable table lock
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified

3)bdr_local>SELECT * FROM v$lock
WHERE id1 = (SELECT object_id FROM all_objects WHERE owner ='HILLS_ISSUE_TRACKER' AND object_name ='B_ISSUE_COMMENTS'); 2

no rows selected

I have taken the bounce of db to release the lock if any. Please help if some body the same issue.

Thanks
Jamsher.