Database Administration (MOSC)
MOSC Banner

ORA-01561: failed to remove all objects in the tablespace specified

edited Jan 22, 2014 2:41AM in Database Administration (MOSC) 12 commentsAnswered ✓
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

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