oracle-11g-新特性-Flashback-Data-Archive-说明.docVIP

oracle-11g-新特性-Flashback-Data-Archive-说明 oracle 11g 新特性 Flashback Data Archive 说明oracle 11g 新特性 Flashback Data Archive 说明 之前整理过一篇Oracle Flashback 的文章。 参考， Oracle Flashback 技术 总结 /tianlesoftware/archive/2009/10/16/4677378.aspx 在Oracle 11g里又出了一个新特性：Oracle Flashback Data Archive. 在11g的官方文档里搜到了相关内容说明，参考： Using Oracle Flashback Technology --Using Flashback Data Archive (Oracle Total Recall) /docs/cd/E11882_01/appdev.112/e17125/adfns_flashback.htm#BJFIEJGG 一. Flashback Data Archive 说明 官网的定义如下： A Flashback Data Archive provides the ability to track and store transactional changes to a table over its lifetime. A Flashback Data Archive is useful for compliance with record stage policies and audit reports. --Flashback Data Archive 在它的有效期内将保存事务改变的信息。 A Flashback Data Archive consists of one or more tablespaces or parts thereof. You can have multiple Flashback Data Archives. If you are logged on as SYSDBA, you can specify a default Flashback Data Archive for the system. A Flashback Data Archive is configured with retention time. Data archived in the Flashback Data Archive is retained for the retention time. -- FDA 包含一个或者多个表空间，我们可以创建多个FDA。 当以sysdba 登陆时，可以指定default FDA。 By default, flashback archiving is off for any table. You can enable flashback archiving for a table if all of these conditions are true: -- 默认情况下，FDA 是关闭的，当具备一下条件时，我们可以启用FDA。 （1）. You have the FLASHBACK ARCHIVE object privilege on the Flashback Data Archive to use for that table. （2）. The table is neither nested, clustered, temporary, remote, or external. （3）. The table contains neither LONG nor nested columns. After flashback archiving is enabled for a table, you can disable it only if you either have the FLASHBACK ARCHIVE ADMINISTER system privilege or you are logged on as SYSDBA. --当FDA 启动以后，只有具有FLASHBACK ARCHIVE ADMINISTER 权限的用户或者用SYSDBA登陆的用户才可以禁用FDA。 When choosing a Flashback Data Archive for a specific table, consider the data retention requirements for the table and the retentio