Re: SQL*Loader parallel load sort order

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 1997/08/19
Message-ID: <01bcace2$9bdd28c0$294b989e@WORKSTATION>#1/1

You might succeed if you work on the following:

Ensure that each Parallel loader will complete its load in a single extent

Start the parallel loaders one at a time, in order of PK value of data loaded

Make each loader's load larger than the load of the previous PK, so that you guarantee

that the loaders finish in the order they start.

In this way you may find that the order of the extents in the segment are in synch with the
order of the PK and the index will create. Received on Tue Aug 19 1997 - 00:00:00 CDT