Database Administration (MOSC)

MOSC Banner

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center