I dropped all the objects using,
select 'DROP ' object_type ' ' owner '.' object_name ';'
from dba_objects
where owner in (upper('&UserName'))
and object_type in ('TABLE', 'VIEW', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'SEQUENCE', 'TRIGGER')
order by object_id desc;
But then, lobs were still present.
select count(1) from dba_objects where owner = 'ANARLIVE';
COUNT(1)
----------
84
1 row selected.
These were coming from recyclebin. So to clear the recycle bin for all users
SQL> purge dba_recyclebin;
DBA Recyclebin purged.
After this lobs were not found.
SQL> select count(1) from dba_objects where owner = 'ANARLIVE';
COUNT(1)
----------
0
1 row selected.
Advertisements