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 Ashburn viewed 'SQL Query to Find Out Timezone Information from Or' 10 mins ago

A visitor from Maryland viewed 'Data Pump IMPDP failed: ORA-31655: no data or meta' 19 mins ago

A visitor from Mumbai viewed 'Data Pump impdp remap_table Option to Change the T' 20 mins ago

A visitor from Guntur viewed 'Data Pump IMPDP failed: ORA-31655: no data or meta' 1 hr 4 mins ago

A visitor from St petersburg viewed 'Data Pump EXPDP IMPDP EXCLUDE and INCLUDE Options ' 1 hr 30 mins ago

Real-time | Get Script | More Info