Drop Oracle Lobs


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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: