Flashback data archive – Using advanced Oracle techniques

This is referred as the database mechanism which allows to store all the row versions in a table over the lifetime. Therefore by using this no versions or stages of the table is lost during the period.

This feature is also a licensed feature whereby which comes along with the advanced compression only and thus adds to the value of the feature.

One need not code complex triggers or codes to transfer the rows to the history tables.

We also don’t need any complex application code to retrieve the data.

When one enables the flash archive it automatically is compressed to conserve the space and occupy.

Once the row versions are compressed one cannot use the DROP or TRUNCATE statement. Also one cannot modify the historical versions.

This archiving operation is a complete online operation where no downtime is expected and is enabled on a table basis.

Please note that while archiving data if the quota increases then the further transactions are blocked.