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”
标签：对象,可以使用,的是,操作,数据