can somebody help what exactly the rollback segment and redo log files contain..

Hai!

iam having some doubt in oracle..
let me explain a scenario..
there is a table A in the database with 1,2,3 rows.. now you are inserting a new row 4 into table A. so what are the additions to the rollback segment and redo-log file as well..
please some body help me..what exactly the rollback segment and redolog files contain..how it will be helpful incase of a recovery..

what i understood in was that..
if a value x=4 is there in the D/B and you are changing the value to a new value..let say x=7..then rollback segment will have the old value(x=4) and redo log file will have both x=4 and x=7.. please somebody help me to get of this problems..

thanks in advance..
regards
Sudhakar Marampelly Received on Fri Oct 19 2001 - 06:56:02 CEST