DB Wiki

User Tools

Site Tools

Trace: • validtimetemporal • flashbackdataarchive
flashbackdataarchive

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
flashbackdataarchive [2015/10/28 12:01] – z0hpvkflashbackdataarchive [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 23: Line 23:
 Create Application ... Create Application ...
 <code>BEGIN <code>BEGIN
-  DBMS_FLASHBACK_ARCHIVE.REGISTER_APPLICATION(+  DBMS_FLASHBACK_ARCHIVE.REGISTER_APPLICATION (
     application_name       => 'DUBETECH_APP',     application_name       => 'DUBETECH_APP',
     flashback_archive_name => 'DUBETECH_FDA');     flashback_archive_name => 'DUBETECH_FDA');
Line 34: Line 34:
     table_name       => 'CUSTOMERS',     table_name       => 'CUSTOMERS',
     schema_name      => 'DUBETECH');     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> END;</code>
  
  
 ==== Import/Export Table History ==== ==== Import/Export Table History ====
 +The history of tables in a FDA can now be imported or exported.
  
flashbackdataarchive.1446033682.txt.gz · Last modified: (external edit)