Oracle误删恢复

query deleted datarows:
	select * from 表名 as of timestamp to_timestamp('删除时间点','yyyy-mm-dd hh24:mi:ss')
	
//Needs Auth [flash any table]
	data table flashback:
   alter table 表名 enable row movement;
   //then
   flashback table 表名 to timestamp to_timestamp(删除时间点','yyyy-mm-dd hh24:mi:ss');
   
database flashback:
	alter database flashback on
	flashback database to scn SCNNO;
	flashback database to timestamp to_timestamp('2007-2-12 12:00:00','yyyy-mm-dd hh24:mi:ss');
	
query droped tables;
	select table_name,dropped from user_tables
	select object_name,original_name,type,droptime from user_recyclebin   
	
restore droped table:
	flashback table 原表名 to before drop
	flashback table "回收站中的表名(如:Bin$DSbdfd4rdfdfdfegdfsf==$0)" to before drop rename to 新表名

不使用安全机制,delete/drop时直接释放空间,purge(净化)
	drop table 表名 purge
     
删除表
	drop table emp cascade constraints
	purge table emp;
删除当前用户的回收站:
    purge recyclebin;
删除所有用户在回收站:
	purge dba_recyclebin


posted on 2013-07-26 18:15  you Richer  阅读(233)  评论(0编辑  收藏  举报