Understanding Flashback Technology - OCP: Oracle Database 12c Administrator Certified Professional - page 361

6 rows selected.
SQL>

On first glance, you might have assumed that this query would have returned the exact
same results as the SHOW RECYCLEBIN command. Instead we see four additional rows showing
the indexes that were moved to the Recycle Bin when we dropped the first JOB_HISTORY table.
The SHOW RECYCLEBIN command shows only tables that reside in the Recycle Bin. It filters
out the dependent objects such as indexes and constraints. Furthermore, the DBA_RECYCLEBIN
view also offers many other columns, as listed in Table 8.2.

TABle 8.2 DBA_RECYCLEBIN Columns

Column Name Description

OWNER The original owner of the dropped object.

OBJECT_NAME The system-assigned name of the object. This is the object's

unique identifier within the Recycle Bin.

ORIGINAL_NAME The original name of the object (at the time when it was dropped).

OPERATION The type of operation that occurred to move the object into the

Recycle Bin (in other words, DROP , TRUNCATE ). Currently, only
dropped objects can be restored.

TYPE The type of object ( TABLE , INDEX , and so on).

TS_NAME The name of the tablespace where the object resides.

CREATETIME Timestamp reflecting when the object was created.

DROPTIME Timestamp reflecting when the object was dropped.

DROPSCN The system change number (SCN) corresponding to the dropping

of the object.

PARTITION_NAME If the dropped object was partitioned, the name of the partition.

CAN_UNDROP This object can be undropped (restored) using the Flashback Drop

option. This is true only for table objects. Dependent objects can
be restored but not by themselves. They will be restored only if
their related table is restored.

CAN_PURGE This object can be purged from the Recycle Bin.

RELATED Object number of the parent object.