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 Washington viewed 'Data Pump IMPDP TABLE_EXISTS_ACTION = APPEND, REPL' 2 hrs 7 mins ago

A visitor from Delhi viewed 'Check/Find Location and Status of Oracle OCR and V' 3 hrs 10 mins ago

A visitor from Quebec viewed 'SQL Query to Find Out Timezone Information from Or' 3 hrs 13 mins ago

A visitor from Edison viewed 'Shell Script to Run RMAN Backup in Background with' 4 hrs 4 mins ago

A visitor from Louisiana viewed 'Oracle Views vs Tables- Advantages, Disadvantages ' 4 hrs 9 mins ago

Real-time | Get Script | More Info