Feature
USER_RECYCLEBIN displays the information about the recycle bin of the current user. Its fields are the same as those of the DBA_RECYCLEBIN view, except that it does not have the OWNER field.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_RECYCLEBIN
Fields
| Field | 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 field 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 field is not supported and is NULL by default. |
| PARTITION_NAME | VARCHAR2(128) | NO | At present, this field 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 field is not supported and is NULL by default. |
| BASE_OBJECT | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| PURGE_OBJECT | NUMBER | NO | At present, this field is not supported and is NULL by default. |
| SPACE | NUMBER | NO | At present, this field is not supported and is NULL by default. |