Re: 10gR2 - direct path load with enabled indexes - lots of undo generated from indexes

> All: Just to clarify, we are talking about undo (rollback data - for
> transaction recovery). Not about redo (online redo logs for crash
> recovery).

From Tom Kyte's forum:

<quote>

q1) you have indexes on the table.  indexes cannot be "appended" to, they must 
be modified.  These modifications must be logged.  The redo/undo for the table 
itself is not generated, the redo/undo for the INDEXES always is.

</quote>

http://tinyurl.com/lujwg



Dimitre

Other related posts: