摘要:
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 阅读全文