Functions and Features of Oracle UNDO

Overview:
UNDO is an oracle method to rollback or undo the changes to the database. UNDO keeps track of the oracle transactions, mainly before the commit of the transaction. Block level changes are recorded ‘in time’ to provide the read consistency.
Why Oracle use the undo?
ð  For transaction rollback
ð  During the database recovery
ð  For instance recovery
ð  For Flashback features
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google