Database Reference
In-Depth Information
Besides the SHOW RECYCLEBIN command, Oracle also offers views named USER_RECYCLEBIN
and DBA_RECYCLEBIN , which can be used to query objects in the Recycle Bin. These views offer
much more information than the simple SHOW RECYCLEBIN command. For example, look at the
following query:
SQL> select original_name, object_name, type, droptime from user_recyclebin;
ORIGINAL_NAME
-------------------------------------------------------------------
OBJECT_NAME
-------------------------------------------------------------------
TYPE DROPTIME
------------------------- -------------------
JOB_HISTORY
BIN$2siLENifTmCBmAu0+mXAuQ==$0
TABLE 2013-09-16:12:45:37
JHIST_DEPT_IX
BIN$oNMhLpjfQDKANxMqxyNTQg==$0
INDEX 2013-09-16:12:45:37
JHIST_JOB_IX
BIN$4ef0bWg/RSqQwyRilF8B7w==$0
INDEX 2013-09-16:12:45:37
JHIST_EMP_ID_PK
BIN$Yy7yGm0/ScmYjpB8SfX9oQ==$0
INDEX 2013-09-16:12:45:37
JHIST_EMPLOYEE_IX
BIN$39LSAx7mSACzu4agKkRYKQ==$0
INDEX 2013-09-16:12:45:37
JOB_HISTORY
BIN$NIaEC81/SJ24Dqr+fTvqTQ==$0
TABLE 2013-09-16:12:55:11
Search WWH ::




Custom Search