Note
This view is available starting with V2.2.77.
Purpose
This view displays information about the recycle bin objects of the current user. The columns are the same as those in the DBA_RECYCLEBIN view, except for the OWNER column.
Applicability
This view applies only to OceanBase Database in Oracle mode.
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 | 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 recycle bin. |
| DROPSCN | NUMBER | NO | Not supported. The default value is NULL. |
| PARTITION_NAME | VARCHAR2(128) | NO | Not supported. The default value is NULL. |
| CAN_UNDROP | VARCHAR2(3) | NO | Whether the object can be restored from the recycle bin: |
| CAN_PURGE | VARCHAR2(3) | NO | Whether the object can be purged: |
| RELATED | NUMBER | NO | Not supported. The default value is NULL. |
| BASE_OBJECT | NUMBER | NO | Not supported. The default value is NULL. |
| PURGE_OBJECT | NUMBER | NO | Not supported. The default value is NULL. |
| SPACE | NUMBER | NO | Not supported. The default value is NULL. |
Sample query
Query information about all recycle bin 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