create table mm as select * from a where rownum<11;
select * from mm
drop table mm
select * from recyclebin where original_name=’MM’ ;–根据表名找回删除的表,如果是删除时间不长可以直接执行where 之前的语句可以按照删除的时间找到删除的表
flashback table MM to before drop;–恢复删除的表
没有权限的情况下恢复删除的记录
delete from MM where partition_id=’344’;–删除一条记录
create table MM1 as (select * from MM as of timestamp sysdate -10/1440)–恢复10分钟以内删除的记录
select * from MM1;