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
- 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