Oracle 9.2.0.1
T1 is an external table accessed through a cursor from another database by using database link
I give command
drop table T1;
which time outs with ORA-4021
Asked
Active
Viewed 274 times
0
-
Is the other database actively accessing the table over the link? Can you [close the database link](https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/managing-a-distributed-database.html#GUID-AF6B5F62-0180-4F8F-A5F0-05246A750CB2) from the remote DB and see if that clears the block? – Alex Poole May 23 '19 at 08:31
-
@AlexPoole the remote session is closed – DesignerAnalyst May 23 '19 at 08:33
-
You can [query the performance views](http://psoug.org/snippet/LOCKS-View-Locked-Objects_866.htm) to see what it locking the table then. – Alex Poole May 23 '19 at 08:42
-
@AlexPoole I have run the query you gave me and returns no rows – DesignerAnalyst May 23 '19 at 09:02