Viewing Recycle Bin Contents

To view recycle bin contents:

Access the Database Home Page, and log in as the owner of the schema of interest.

See "Accessing the Database Home Page" for instructions.
Click the Utilities icon, and then click the Recycle Bin icon.
Click the Dropped Objects icon.

The Dropped Objects page appears, showing a list of dropped objects and dependent objects. (For example, if a table appears in the list, all of its indexes and other dependent objects appear also.)

Description of the illustration dropped_objects.gif
(Optional) Narrow down the list contents by selecting an object type from the Object Type list and clicking Go.
(Optional) Narrow down the list by entering search text into the Original Name field and clicking Go.

All objects that include the search text anywhere in their original name are displayed. For example, assuming that the list of dropped objects is the one shown in the previous screen snapshot, if you enter JOB for your search text, only the objects JOB_HISTORY and JHIST_JOB_IX appear in the list.
(Optional) Click an object link (under the Original Name column) to view object details.