13
Flashback Management for Reconstructing the Database Image
Security, integrity, and data consistency are integral parts of relational database systems. Transaction management allows you to transfer the database from one consistent image to another. It must be ensured that any change in the confirmed transaction is consistent, satisfying all integrity rules and constraints. Some rules do not need to be applied immediately during the operation’s execution typically related to referential integrity. However, to reach COMMIT (transaction approval), all data constraints must be passed.
In this chapter, we will look at how transaction logs can be used to retrieve historical versions of objects. We looked at the Flashback data archive in Chapter ...
Get Developing Robust Date and Time Oriented Applications in Oracle Cloud now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
