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

Column Name Description

RECYCLEBIN NAME

This column shows the system-assigned name of the object. This is
the object's unique identifier within the Recycle Bin.

OBJECT TYPE

This column shows the type of the object ( TABLE , INDEX , and so on).

DROP_TIME

This column shows the timestamp corresponding to the dropping of
the object.

Next, we will create a new table named JOB_HISTORY , insert some data, and then drop it.
We will then look in the Recycle Bin to verify that both tables are there, even though both
tables had the same name.

SQL> create table job_history (job_id number) tablespace users;

Table created.

SQL> insert into job_history values(1);

1 row created.

SQL> commit;

Commit complete.

SQL> drop table job_history;

Table dropped.

SQL> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------

JOB_HISTORY BIN$2siLENifTmCBmAu0+mXAuQ==$0 TABLE 2013-09-16:12:45:37
JOB_HISTORY BIN$NIaEC81/SJ24Dqr+fTvqTQ==$0 TABLE 2013-09-16:12:55:11

SQL>

As promised, Oracle assigned the second version of the JOB_HISTORY table a unique
identifier ( RECYCLEBIN NAME ). This ensures that either version of the table could be restored
if required.