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

_____________________________________________________________________________________________________________________

0 comments:

Post a Comment

 

acehints.com Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google