如果启动了flashback的话,可以闪回查询原来的记录。 语法如下: select ... from <tablename> as of timestamp to_date ... where ...; select ... from <tablename> as of timestamp scn ... where ... ;================================================================== Inthirties关注Oracle数据库 优化,安全,备份,恢复,迁移,故障处理如果你需要帮助或想和我一起学习的请联系 联系方式QQ:370140387 QQ群: 85837884(注明:数据库) 电子邮件:[email protected] 网站: http://www.inthirties.com
我还能查到他6个小时之前的数据情况??
不能回滚 只查看哦?
语法如下:
select ... from <tablename> as of timestamp to_date ... where ...;
select ... from <tablename> as of timestamp scn ... where ... ;==================================================================
Inthirties关注Oracle数据库 优化,安全,备份,恢复,迁移,故障处理如果你需要帮助或想和我一起学习的请联系
联系方式QQ:370140387
QQ群: 85837884(注明:数据库)
电子邮件:[email protected]
网站: http://www.inthirties.com