DROP tablespace takes eternity
We are migrating to OATM , and as part of the finishing task we are dropping our old tablespaces.
One of the custom tablespaces (dictionary managed) is taking forever.It looks like it's clearing all the extents from the table sys.fet$ and its going too slow with that.
Please note that the tablespace has no objects in it.
The following query returns nothing
Select * from dba_segments where tablespace_name = <tablespace>
I've no clue why this operation is taking so long , i did bounce the Database but that also didnt help.
I'm now attempting to convert the tablespace to locally managed , and if that succeed i'll try to drop that.But converting the tablespace to LMT is also taking too long.