Database Administration (MOSC)

MOSC Banner

How to get rid of orphan LOB objects (segments)

edited Oct 1, 2014 11:25AM in Database Administration (MOSC) 12 comments
After dropping all objects (tables, views, synonyms, sequences, packages) from a schema, there remained a few objects of type LOB, for which the corresponding segments take up some space.

They are still registered in the USER_OBJECTS and USER_SEGMENTS views, but not in USER_LOBS, not even in DBA_LOBS.

Their names are system generated, of the kind of SYS_LOB0000240626C00011$$.

Is there any way how to get rid of such objects without dropping and recreating the schema?

Thanks for any ideas.

Pavel

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