Re: redo and undo
Date: Tue, 06 Mar 2012 01:51:10 +0000
Message-Id: <E1S4jYU-000OqF-Jf_at_pr-webmail-2.demon.net>
The purpose of the log miner output is to convert the redo entries into the equivalent SQL statement that would produce the same effect - and you don't write statements to update indexes or undo block. The statement supplied would update the indexes and undo blocks as a side effect.
Regards
Jonathan Lewis
cure_at_austin.rr.com wrote:
> Hi All,
>
> Let's say I run the following command... insert into cure.thecure
> (firstname ,lastname) values('oracle','11gr2'); The table has an index on
> the lastname column...
>
> Using Log Miner, There is redo and undo for the table block. The book I'=
> m
> reading said that all 3 types of blocks (undo, table, index) have generat=
> ed
> redo to protect them. I'm lost here because I do not see redo for the ind=
> ex
> block or the undo block. I only see redo and undo for the table block.
>
> Any help is greatly appreciated.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 05 2012 - 19:51:10 CST