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
|
|
