Re: Incredibly slow load into a partitioned IOT (2nd attempt)

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: 2 Nov 2001 00:08:26 -0800
Message-ID: <bde5777e.0111020008.583b3e16@posting.google.com>

Hello stephen,

Your load process suffers probably from writing lots of rollback and redo, because of the index maintenance.

what I would do in this case:
A1. Use direct mode in sqlloader, if possible.

If that's not an option (e.g. sql-expressions in control-file).

B1. Create a load-table: same structure as the IOT, put 'plain'.
B2. Load the data using sqlloader in the load-table
B3. Load the IOT using 'insert /*+ append */ select ... from

load-table.

It probably saves you many hours.

Herman de Boer
IT Consultancy Group B.V. Received on Fri Nov 02 2001 - 02:08:26 CST