Purge Recycle Bin

Go Up to Available object actions by DBMS

This action builds and submits a PURGE RECYCLEBIN, PURGE DBA_RECYCLEBIN, PURGE TABLESPACE tablespacename, or PURGE TABLESPACE tablespacename USER username statement. This lets you select one of the following purge Recycle Bin options:

• Purge all objects belonging to the current user
• Purge all objects belonging to all users
• Purge all objects residing on a specified tablespace
• Purge all objects residing on a specified tablespace and belonging to a specified user

Platform Availability

• ORCL 10g ^

To Purge Objects in the Recycle Bin Tables and Associated Objects

1. In DBArtisan, expand the Schema node, right-click the Recycle Bin node and select Purge Recycle Bin from the context menu.

2. Use the following table as a guide to understanding and modifying settings on the Confirm Purge Recycle Bin wizard:

Panel	Settings and tasks
Action Options	Purge	Select a PURGE option type: RECYCLEBIN purges all objects belonging to the current user. DBA_RECYCLEBIN purges objects system wide. TABLESPACE purges objects residing on a specific tablespace.
	Tablespace	If you selected a Purge value of TABLESPACE, select the tablespace for which all residing objects will be purged. Optionally, use the User control to further qualify the objects that will be purged.
	User	If you selected a Purge value of TABLESPACE, you can use this control to restrict purging to only those tablespace-residing objects belonging to a particular user.
Preview	Displays the DDL that will execute the object action. For details, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.

Topics

• Recycle Bin (for a support summary including topics such as displaying Recycle Bin contents)
• Enable Recycle Bin
• Flashback Recycle Bin Entry
• Purge Recycle Bin Entry