Oracle 视图 DBA_RECYCLEBIN 官方解释，作用，如何使用详细说明
本站中文解释
Oracle的视图DBA_RECYCLEBIN保存的是被DROP操作的用户对象，也就是垃圾箱里的数据，如果要使用DBA_RECYCLEBIN，可以使用以下语法:
SELECT * FROM DBA_RECYCLEBIN;
这句话会将所有数据库中被DROP 的对象显示出来，我们可以从中看出对象名称、拥有者、操作时间以及提示是否可以UNDROP，通过DBA_RECYCLEBIN可以方便定位在误删除了数据库对象内容之后可以再次还原，可以使用FLASHBACK TABLE 和 FLASHBACK DROP语句来完成。
官方英文解释
DBA_RECYCLEBIN displays information about all recycle bins in the database.
Related View
USER_RECYCLEBIN displays information about the recycle bin owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the original owner of the object |
|
|
|
|
New name of the object |
|
|
|
Original name of the object |
|
|
|
|
Operation carried out on the object:
|
|
|
|
|
Type of the object:
|
|
|
|
|
Name of the tablespace to which the object belongs |
|
|
|
|
Timestamp for the creation of the object |
|
|
|
|
Timestamp for the dropping of the object |
|
|
|
|
System change number (SCN) of the transaction which moved the object to the recycle bin |
|
|
|
|
Name of the partition which was dropped |
|
|
|
|
Indicates whether the object can be undropped ( |
|
|
|
|
Indicates whether the object can be purged ( |
|
|
|
|
|
Object number of the parent object |
|
|
|
|
Object number of the base object |
|
|
|
|
Object number for the object which gets purged |
|
|
|
Number of blocks used by the object |
See Also:
“USER_RECYCLEBIN”
