ORA-01561: failed to remove all objects in the tablespace when trying to drop empty TS
Hey,
On my dev oracle db - 12.2.0.1 (linux x86-64) i'm trying to drop empty tablespace (it wasn't empty earlier, but i dropped or moved to another ts all objects). I find nothing in dba_extents, dba_segments, dba_objects etc.
But it gives me:
ORA-01561: failed to remove all objects in the tablespace
I found hcheck script on MOS and ran that. It gave me output:
ORPHAN SEG$: SegType=DATA TS=81 RFILE/BLOCK=99/4194194
So i'm searching any solution what to do next because i'm afraid that deleting row from sys.seg$ is not the best idea i can imagine.