FLASHBACK TABLE

误删除了table,在10g以后可以通过flashback table来实现复原.

1.首先数据库recyclebin参数要设置成on状态
Normal 0 false false false EN-US ZH-TW X-NONE ALTER SESSION SET recyclebin = ON/OFF;

2.查看要复原的表
SELECT * FROM DBA_RECYCLEBIN WHERE wner='CHRIS';

CHRIS     BIN$fIp6hjBngAHgQBKsZkF4xw==$0     CHRIS_FSH     DROP     TABLE     DATA     2009-09-10:15:17:03     2010-01-07:10:03:34     73151879481                                    YES     YES     70182                                     70182                                     70182                                     128                                  

3.复原表
FLASHBACK TABLE chris_fsh TO BEFORE DROP RENAME TO chris_fsh_test;
Flashback complete.

当然,如果想及时释放删除表后的空间,可以进行PURGE操作.
PURGE TABLE chris_fsh;
Table purged.

以上,记录备用.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/475734/viewspace-624554/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/475734/viewspace-624554/