摘要：
Flashback Version Query:ConsiderationsThe VERSIONS clause cannot be used to query:External tablesTemporary tablesFixed tablesViewsThe VERSIONS clause cannot span DDL commands.Segment shrink operations are filtered out.在哪种情况下可以使用flashback versions query只能是commited以后的数据只能是dml语句，ddl不行；ddl以后，前面的dml也查询不到 阅读全文
摘要：
Flashback Version Query/******************************************/实验：跟踪数据不同版本之间的事物变化目的：利用flashback query data,使用dml进行数据恢复/******************************************/SQL> show userUSER is "U2"SQL> create table m(id int,name varchar2(10));Table created.SQL> insert into m values(0,& 阅读全文
摘要：
Guaranteeing Unod RetentionSQL> select ts#,name,included_in_database_backup,bigfile,flashback_on,encrypt_in_backup from v$tablespace; TS# NAME INCLUDED_IN_DATABASE_BACKUP BIGFILE FLASHBACK_ON ENCRYPT_IN_BACKUP---------- --------------- ------------------------------ -------... 阅读全文
摘要：
ObjectivesAfter completing this lesson,you should be able to :Describe Flashback technologyPerform Flashback QueryUse Flashback Version QueryEnable row movement on a tablePerform Flashback Table operationsUse Flashback Transaction QueryUse Flashback TransactionPreparing Your Database for FlashbackCr 阅读全文