Re: 10gR2 - direct path load with enabled indexes - lots of undo generated from indexes
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: <kutrovsky.oracle@xxxxxxxxx>
- Date: Tue, 30 May 2006 22:59:37 +0200
> 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: