Purge Recycle Bin Entry

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action builds and submits a PURGE INDEX or PURGE TABLE statement, letting you permanently delete tables or indexes from the Oracle Recycle Bin. Once purged, the tables or indexes and any associated objects that were contained in the Recycle Bin are no longer retrievable.

Note: The Datasource Navigator/Explorer entry for a Recycle Bin entry has a Can Purge field that indicates whether a Purge Recycle Bin Entry action can be performed against the item

Platform Availability

To Permanently Purge Selected Tables or Indexes Currently in the Recycle Bin

1. In the DBArtisan Datasource Navigator/Explorer, under an Oracle Schema node, select the Recycle Bin node. Contents of the Recycle Bin are displayed.
2. Right-click one or more selected tables or indexes in the Recycle Bin and select Purge Recycle Bin Entry from the context menu. The Confirm Purge Recycle Bin Entry dialog opens.
3. Use the following table as a guide to understanding and modifying settings in the wizard:
Step Settings and tasks

Action options

Displays the table and index entries you selected to purge.

Dependencies

Review the referring and referred objects that will be automatically resolved when you execute this operation. For details, see Dependencies.

Preview

Preview the DDL generated for the operation. For more information, see Preview.

4. Click Execute. For information on the scheduling option, see Scheduling.
Note: When dropping tables on a datasource with the Recycle Bin feature enabled, the Drop action has an option that lets you immediately purge the table.

Topics