清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
SQL>show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
select * from u_power as of timestamp to_timestamp('2014-03-09 08:00:00', 'yyyy-mm-dd hh24:mi:ss');
flashback table u_power to timestamp to_timestamp ('2014-03-10 08:00:00', 'yyyy-mm-dd hh24:mi:ss');