SQL> create table test (col_a varchar(4)); Table created. SQL> select object_name, original_name, type, createtime, droptime from user_recyclebin; no rows selected SQL> drop table test; Table dropped. SQL> select object_name, original_name, type, createtime, droptime from user_recyclebin; OBJECT_NAME ORIGINAL_NAME TYPE CREATETIME DROPTIME ------------------------------ ---------------- ------ ------------------- -------- ----------- BIN$0+ktoVCgEmXgNAAADiUEHQ==$0 TEST TABLE 2004-02-21:19:04:03 2004-02- 21:19:04:41 SQL> create table test (col_b varchar(4)); Table created. SQL> select object_name, original_name, type, createtime, droptime from user_recyclebin; OBJECT_NAME ORIGINAL_NAME TYPE CREATETIME DROPTIME ------------------------------ ---------------- ------ ------------------- -------- ----------- BIN$0+ktoVChEmXgNAAADiUEHQ==$0 TEST TABLE 2004-02-21:19:07:33 2004-02- 21:19:08:17 SQL> drop table test; Table dropped. SQL> select object_name, original_name, type, createtime, droptime from user_recyclebin; OBJECT_NAME ORIGINAL_NAME TYPE CREATETIME DROPTIME ------------------------------ ---------------- ------ ------------------- -------- ----------- BIN$0+ktoVCgEmXgNAAADiUEHQ==$0 TEST TABLE 2004-02-21:19:04:03 2004-02- 21:19:04:41 BIN$0+ktoVChEmXgNAAADiUEHQ==$0 TEST TABLE 2004-02-21:19:07:33 2004-02- 21:19:08:17 SQL> show recyclebin ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ---------------- ------------------------------ ------------ ------------------- TEST BIN$0+ktoVChEmXgNAAADiUEHQ==$0 TABLE 2004-02-21:19:08:17 TEST BIN$0+ktoVCgEmXgNAAADiUEHQ==$0 TABLE 2004-02-21:19:04:41