Note
This view is available starting with V1.4.
Purpose
This view displays information about recyclebin objects owned by the current user. The columns in this view are the same as those in DBA_RECYCLEBIN, except that the OWNER column is removed.
Applicability
This view is available only in Oracle mode of OceanBase Database.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| OBJECT_NAME | VARCHAR2(128) | NO | The new name of the object. |
| ORIGINAL_NAME | VARCHAR2(128) | NO | The original name of the object. |
| OPERATION | VARCHAR2(9) | NO | This column is not supported. The default value is NULL. |
| TYPE | VARCHAR2(25) | NO | The type of the object. |
| TS_NAME | VARCHAR2(30) | NO | The name of the table to which the object belongs. |
| CREATETIME | VARCHAR2(19) | NO | The time when the object was created. |
| DROPTIME | VARCHAR2(19) | NO | The time when the object was moved to the recyclebin. |
| DROPSCN | NUMBER | NO | This column is not supported. The default value is NULL. |
| PARTITION_NAME | VARCHAR2(128) | NO | This column is not supported. The default value is NULL. |
| CAN_UNDROP | VARCHAR2(3) | NO | Indicates whether the object can be restored from the recyclebin:
|
| CAN_PURGE | VARCHAR2(3) | NO | Indicates whether the object can be purged:
|
| RELATED | NUMBER | NO | This column is not supported. The default value is NULL. |
| BASE_OBJECT | NUMBER | NO | This column is not supported. The default value is NULL. |
| PURGE_OBJECT | NUMBER | NO | This column is not supported. The default value is NULL. |
| SPACE | NUMBER | NO | This column is not supported. The default value is NULL. |
Sample query
Query information about all recyclebin objects in the database.
obclient [SYS]> SELECT * FROM SYS.USER_RECYCLEBIN;
The query result is as follows:
+----------------------------------+---------------+-----------+-------+---------+---------------------+---------------------+---------+----------------+------------+-----------+---------+-------------+--------------+-------+
| OBJECT_NAME | ORIGINAL_NAME | OPERATION | TYPE | TS_NAME | CREATETIME | DROPTIME | DROPSCN | PARTITION_NAME | CAN_UNDROP | CAN_PURGE | RELATED | BASE_OBJECT | PURGE_OBJECT | SPACE |
+----------------------------------+---------------+-----------+-------+---------+---------------------+---------------------+---------+----------------+------------+-----------+---------+-------------+--------------+-------+
| RECYCLE_$_10001_1751443977775016 | TEST | NULL | TABLE | NULL | 02-JUL-25 04.12.47. | 02-JUL-25 04.12.57. | NULL | NULL | YES | YES | NULL | NULL | NULL | NULL |
+----------------------------------+---------------+-----------+-------+---------+---------------------+---------------------+---------+----------------+------------+-----------+---------+-------------+--------------+-------+
1 row in set