是否有辦法像WINDOWS一樣從資源回收桶找回來.
在ORACLE 10G版本,recyclebin預設是啟用的.可以透過
USER_RECYCLEBIN and DBA_RECYCLEBIN還有機會找回來被DROP的TABLE
(下面指令是用DBA的身分執行,如果需要用一般USER請自行改用USER_RECYCLEBIN及相關適當修改)
不過要注意TABLESPACE的使用率,如果TABLESPACE滿到一個程度
資源回收的部分會被PURGE掉,
DESC DBA_RECYCLEBIN看下欄位
| Name | Null? | Type |
| ----------------------------------------- | -------- | ---------------------------- |
| OWNER | NOT NULL | VARCHAR2(30) |
| OBJECT_NAME | NOT NULL | VARCHAR2(30) |
| ORIGINAL_NAME | VARCHAR2(32) | |
| OPERATION | VARCHAR2(9) | |
| TYPE | VARCHAR2(25) | |
| TS_NAME | VARCHAR2(30) | |
| CREATETIME | VARCHAR2(19) | |
| DROPTIME | VARCHAR2(19) | |
| DROPSCN | NUMBER | |
| PARTITION_NAME | VARCHAR2(32) | |
| CAN_UNDROP | VARCHAR2(3) | |
| CAN_PURGE | VARCHAR2(3) | |
| RELATED | NOT NULL | NUMBER |
| BASE_OBJECT | NOT NULL | NUMBER |
| PURGE_OBJECT | NOT NULL | NUMBER |
| SPACE | NUMBER |
