摘要
简述了oracle10g中闪回查询的类型,通过列举实例说明了闪回版本查询和闪回事物查询的应用。闪回查询是最基本的闪回功能,直接利用回滚段中的旧数据构造某一刻的一致性数据版本。由于该查询只适合单个表数据恢复,所以对事务中相关的多表数据恢复不适合,无法确保相关数据的参照完整性。
This paper describes the Oracle 10g flashback query types,through examples the flashback version query and flashback query applications.Flashback query is the most basic flashback function,the direct use of the consistency of the data version of the rollback segments in the old data structure at a certain moment.Because this query is only suitable for a single table data recovery,on the affairs related to multiple tables for data recovery,can not ensure data integrity.
出处
《电脑开发与应用》
2012年第12期50-51,共2页
Computer Development & Applications