ITPUB

Aug 25, 2016 · Databases

Unlock Historical Table Snapshots with Oracle Flashback Data Archive

Oracle 11g’s Flashback Data Archive lets you retain UNDO information for extended periods, enabling point-in-time queries of tables; this guide walks through creating an ASSM tablespace, setting up a flashback archive, assigning tables, and using SCN-based queries to retrieve past data.