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 = 'MISLIVE'; 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 = 'MISLIVE'; COUNT(1) ---------- 0 1 row selected.