DBA_RECYCLEBIN
功能描述
DBA_RECYCLEBIN系统视图用户查询所有用户的所有回收站对象。
字段说明
| 字段名 | 类型 | 说明 |
|---|---|---|
| DB_ID | INTEGER | 库ID |
| USER_ID | INTEGER | 所有者ID |
| OBJECT_ID | INTEGER | 对象ID |
| RELATEDOBJ_ID | INTEGER | 父对象ID |
| OBJECT_TYPE | INTEGER | 对象类型 |
| OBJECT_TYPE_NAME | VARCHAR | 对象类型名 |
| SCHEMA_ID | INTEGER | 模式ID |
| OBJECT_NAME | VARCHAR | 对象原名 |
| RECYCLE_NAME | VARCHAR | 回收站唯一名 |
| DROPED_TIME | DATETIME | 删除时间 |
| CAN_UNDROP | VARCHAR | 是否可以从回收站恢复 |
| CAN_PURGE | VARCHAR | 是否可以删除 |
| RESERVED1 | VARCHAR | 保留字段 |
示例
sql
SQL> SELECT * FROM SYS_RECYCLEBIN;
DB_ID | USER_ID | OBJECT_ID | RELATEDOBJ_ID | OBJECT_TYPE | OBJECT_TYPE_NAME | SCHEMA_ID | OBJECT_NAME | RECYCLE_NAME | DROPED_TIME | CAN_UNDROP | CAN_PURGE | RESERVED1 |
------------------------------------------------------------------------------
1 | 1 | 1048619 | 1048619 | 5 | Table| 1 | INDEX_TABLE1| BIN$0800010008| 2024-01-08 11:23:56.129 AD | YES| YES| <NULL>|
1 | 1 | 1048620 | 1048619 | 10 | Index| 1 | PK_IDX_S391217047130122| BIN$0E0000000B| 2024-01-08 11:23:56.129 AD | NO| YES| <NULL>|
1 | 101 | 1048625 | 1048625 | 5 | Table| 101 | INDEX_TABLE3| BIN$080001000B| 2024-01-08 13:41:43.262 AD | YES| YES| <NULL>|
1 | 101 | 1048626 | 1048625 | 10 | Index| 101 | PK_IDX_S1904517047212935| BIN$0E0000000E| 2024-01-08 13:41:43.262 AD | NO| YES| <NULL>|
Total 4 records.
Use time:1 ms.