DB Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== Flashback Data Archive =====

==== User-Context Tracking ====
The user context can now be tracked with FDA and therefore see which user made changes to a table.\\
Use DBMS_FLASHBACK_ARCHIVE.SET_CONTEXT_LEVEL procedure to do this ...
<code>ALL     : All contexts from the SYS_CONTEXT function are stored.
TYPICAL : Only basic auditing attributes from the USERENV context are stored.
NONE    : No context information is stored.

EXEC DBMS_FLASHBACK_ARCHIVE.SET_CONTEXT_LEVEL('TYPICAL');</code>

Use DBMS_FLASHBACK_ARCHIVE.GET_SYS_CONTEXT function to retrieve the data ...
<code>SELECT DBMS_FLASHBACK_ARCHIVE.GET_SYS_CONTEXT(versions_xid, 'USERENV','SESSION_USER')
FROM   FDA_TABLE
       VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 1 AND SYSTIMESTAMP;</code>



==== 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.