Functions and Features of Oracle UNDO

advertisements

_____________________________________________________________________________________________________________________

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

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Xinjiang viewed 'Unable to Bring Up RAC Clusterware: ORA-15081: fai' 2 hrs 8 mins ago

A visitor from Columbus viewed 'Data Pump Expdp ESTIMATE_ONLY Parameter' 2 hrs 42 mins ago

A visitor from Ningxia viewed 'How to setup Oracle 11g, 10g Transparent Data Encr' 4 hrs 26 mins ago

A visitor from Wellington viewed 'Fix ORA-01927: cannot REVOKE privileges you did no' 4 hrs 35 mins ago

A visitor from Wellington viewed 'Fix ORA-01927: cannot REVOKE privileges you did no' 4 hrs 45 mins ago

Real-time | Get Script | More Info