数据库恢复到指定时间的表记录
数据库恢复到指定时间的表记录
Java代码
** 闪回
Java代码
<span style="font-size: 1em; line-height: 1.5;">查询某一时间点的数据
<span style="font-size: 1em; line-height: 1.5;">select * from gs_grid_info as of timestamp to_timestamp('2013-05-09 9:00:47', 'yyyy-mm-dd hh24:mi:ss');</span></span>
Java代码
Java代码
允许数据表行移动
alter table gs_grid_relation enable row movement;
恢复到指定时间的表记录
flashback table gs_grid_relation to timestamp to_timestamp('2013-05-09 10:00:00','yyyy-mm-dd hh24:mi:ss');
Java代码
** 差异
select * from B minus select * from A;
比较表结构相同的两表之间的差异用minus。
select * from gs_grid_info minus
select * from gs_grid_info as of timestamp to_timestamp('2013-05-09 9:00:47', 'yyyy-mm-dd hh24:mi:ss');