When using Oracle 10g features around the flashback technology it's important to know the differences between the individual options and their respective restrictions. The Flashback Table, Flashback Query, Flashback Transaction Query and Flashback Version Query are all based on undo (or rollback) data option, which primarily provides read consistency and rolling back transactions in Oracle 10g. However, Flashback Database is based on before images in the flashback logs and Flashback Drop is based on another 10g feature called the Recycle Bin, which is there to manage dropped database objects until their space is required to store new data.
Oracle Metalink has some very useful documents relating to these features:
- Note 249319.1 - Configure flashback database
- Note 270060.1 - Use Flashback Table Feature and Resolve errors
- Note 270535.1 - Restrictions on Flashback Table Feature
- Note 317499.1 - 10G Oracle Flashback Transaction Query - Introduction and usage
- Note 369755.1 - Flashback Logs-Space management
- Note:435998.1 - What Do All 10g Flashback Features Rely on and what are their Limitations
Leave a comment