PURGE RECYCLEBIN


Syntax:


   PURGE RECYCLEBIN

   PURGE DBA_RECYCLEBIN

   PURGE USER_RECYCLEBIN

   PURGE TABLE TableName


Examples


Drop a table, bypassing the recyclebin:
drop table ANAR purge;

Disable the recyclebin for this session:
ALTER SESSION SET RECYCLEBIN=OFF;

If using a 9i client against a 10g database, the client won't know what purge is, so use execute immediate:

begin
execute immediate 'purge recyclebin';
end;
 
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: