In case of update, oracle keeps the past image in the undo segments. The purpose of undo is :
1.meant for read consistancey.
2.transaction rollback.
3.transaction recovery.
4.instance recovery.
Data file contains commited data as well as uncommited data.
No comments:
Post a Comment