Note
This view is available starting with V1.4.
Purpose
This view displays information about the recyclebin objects owned by the current user. Its columns are the same as those in DBA_RECYCLEBIN, except the OWNER column.
Applicability
This view is available only in OceanBase Database in Oracle-compatible 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 | 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 recovered 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