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@xxxxxxxxxxxxx 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. > -- //www.freelists.org/webpage/oracle-l