Purpose
The USER_RECYCLEBIN view displays information about the recycle bin of the current user. Its columns are the same as those of the DBA_RECYCLEBIN view, except that it does not have the OWNER column.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_RECYCLEBIN
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 | At present, this column is not supported and is NULL by default. |
| TYPE | VARCHAR2(25) | NO | The type of the object. |
| TS_NAME | VARCHAR2(30) | NO | The name of the tablespace 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 dropped into the recycle bin. |
| DROPSCN | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| PARTITION_NAME | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| CAN_UNDROP | VARCHAR2(3) | NO | Indicates whether the object can be restored from the recycle bin. Valid values: |
| CAN_PURGE | VARCHAR2(3) | NO | Indicates whether the object can be purged. Valid values: |
| RELATED | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| BASE_OBJECT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| PURGE_OBJECT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| SPACE | NUMBER | NO | At present, this column is not supported and is NULL by default. |