Differences

This shows you the differences between two versions of the page.

--- flashbackdataarchive [2015/10/28 11:56] – z0hpvk
+++ flashbackdataarchive [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 18: / Line 18: @@
 ==== Database Hardening ====
+You can now group a set of tables in a Flashback Archive.
+These tables are known as Applications.
+Create Application ...
+<code>BEGIN
+  DBMS_FLASHBACK_ARCHIVE.REGISTER_APPLICATION (
+    application_name       => 'DUBETECH_APP',
+    flashback_archive_name => 'DUBETECH_FDA');
+END;</code>
+Add Tables to Application ...
+<code>BEGIN
+  DBMS_FLASHBACK_ARCHIVE.ADD_TABLE_TO_APPLICATION (
+    application_name => 'DUBETECH_APP',
+    table_name       => 'CUSTOMERS',
+    schema_name      => 'DUBETECH');
+END;</code>
+Use ENABLE_APPLICATION to enable all tables in application for FDA.
+<code>BEGIN
+  DBMS_FLASHBACK_ARCHIVE.ENABLE_APPLICATION (application_name => 'DUBETECH_APP');
+END;</code>
 ==== Import/Export Table History ====
+The history of tables in a FDA can now be imported or exported.