DB Wiki

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 …

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');

Use DBMS_FLASHBACK_ARCHIVE.GET_SYS_CONTEXT function to retrieve the data …

SELECT DBMS_FLASHBACK_ARCHIVE.GET_SYS_CONTEXT(versions_xid, 'USERENV','SESSION_USER')
FROM   FDA_TABLE
       VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 1 AND SYSTIMESTAMP;

You can now group a set of tables in a Flashback Archive. These tables are known as Applications.

Create Application …

BEGIN
  DBMS_FLASHBACK_ARCHIVE.REGISTER_APPLICATION(
    application_name       => 'DUBETECH_APP',
    flashback_archive_name => 'DUBETECH_FDA');
END;

Add Tables to Application …

BEGIN
  DBMS_FLASHBACK_ARCHIVE.ADD_TABLE_TO_APPLICATION (
    application_name => 'DUBETECH_APP',
    table_name       => 'CUSTOMERS',
    schema_name      => 'DUBETECH');
END;

Use ENABLE_APPLICATION to enable all tables in application for FDA.

BEGIN
  DBMS_FLASHBACK_ARCHIVE.ENABLE_APPLICATION(
    application_name => 'DUBETECH_APP');
END;