alter table tt enable row movement; flashback table tt to timestamp to_timestamp('2008-09-12 15:00:00','yyyy-mm-dd hh24:mi:ss'); flashback database to timestamp to_timestamp('2008-09-12 15:00:00','yyyy-mm-dd hh24:mi:ss');把时间换下。
alter table tt enable row movement; flashback table tt to timestamp to_timestamp('2008-09-12 15:00:00','yyyy-mm-dd hh24:mi:ss');
闪回或者RMAN,按时间不完全恢复前提是有备份.
create table tt as select * from sm_funcregister as of timestamp to_timestamp('05/19/2008 08:00:00','mm/dd/yyyy hh24:mi:ss');然后将原来的表中的数据清除,再将tt表中的数据插入到原表中就可以了
flashback table tablename to before drop;
rman;
就是说闪回吗?
http://database.ccidnet.com/art/1107/20061116/952915_1.html
上面这个.
我们这边也是oracle9, 没2楼的功能, 用闪回查询到我自己delete的数据再插入就OK了吧?
flashback table tt to timestamp to_timestamp('2008-09-12 15:00:00','yyyy-mm-dd hh24:mi:ss');
flashback database to timestamp to_timestamp('2008-09-12 15:00:00','yyyy-mm-dd hh24:mi:ss');把时间换下。
flashback table tt to timestamp to_timestamp('2008-09-12 15:00:00','yyyy-mm-dd hh24:mi:ss');