(The flashback data archiving feature in Oracle Database 11g overcomes most of these limitations. It automatically tracks every change to the data stored in the database, thus maintaining a secure, efficient, and easily accessible historical data archive. As long as the business needs, the captured historical data will be retained and can be easily accessed using the standard SQL structure. Historical data tracking can be enabled immediately for existing and new tables, and more importantly, in a way that is completely transparent to the application.
Implemented locally in the database, flashback data archiving provides a high-performance, storage optimized solution and a centralized management interface to meet the needs of enterprise data retention and change control. The main advantages of using flashback data archive for history tracking include:)