ORA-01561: failed to remove all objects in the tablespace specified
I am trying to drop a tablespace but keep getting the ORA-01561. I have tried several times over several days and nothing has changed. There is nothing in dba_segments for the tablespace. However, seg$ does have one segment. I don't know how seg$ can have something and dba_segments does not. Further I don't know how to identify what segment seg$ believes is there so I can try moving it to a different tablespace. I have also tried export and expdp on the tablespace to see if they would find anything and they do not. I'm wondering if something is corrupted
0