How to get rid of orphan LOB objects (segments)
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