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: