flashbackdataarchive
This is an old revision of the document!
Table of Contents
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 …
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.
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;
Database Hardening
Import/Export Table History
flashbackdataarchive.1446033296.txt.gz · Last modified: 2025/03/08 22:23 (external edit)