Oracle LOB delete

LOB object drop error
oracle drop lob objects


after delete all the object schema .... LOB still exists .


select count(*) from dba_objects where owner='TIME' ;

COUNT(*)
--------------------
4



apt-rdbms-01.aptus.co.uk:APTDB\sys> select object_type,owner,object_name from dba_objects where owner='TIME' ;

OBJECT_TYPE OWNER
------------------- ------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------------------------------------------------------
LOB TIME
SYS_LOB0000075558C00003$$

LOB TIME
SYS_LOB0000075618C00006$$

LOB TIME
SYS_LOB0000075652C00006$$

LOB TIME
SYS_LOB0000075693C00003$$






apt-rdbms-01.aptus.co.uk:APTDB\sys> purge dba_recyclebin;

DBA Recyclebin purged.

apt-rdbms-01.aptus.co.uk:APTDB\sys> select object_type,owner,object_name from dba_objects where owner='TIME' ;

no rows selected




purge recyclebin;