Commit/Rollback and Redo Log files....
Aman....Dec 26 2007 — edited Dec 28 2007Hi there,
Probably its a very simple question but still will ask. Some of the answers I know but I hope I shall get some out-of-the-box answers so asking this.
1) Why do we need redo log files? Why can't we work without redo log files? I mena to say that if redo log files were missing from teh standard architecture than what will be the consequences ?
2) What happens when we issue a commit and Rollback?
Hope to get some replies.
With thanks in advance,
Aman....