Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader parallel load sort order
Was the data sorted in ascending order ?
-- Bob Gator Bait Software Michael <M.Jessen_at_austrac.gov.au> wrote in article <01bcaba8$d372c1e0$67291ccb_at_internet-3>...Received on Mon Aug 18 1997 - 00:00:00 CDT
> I'm planning a reorg of a largeish (600 million rows) table. My objective
...
> primary key. I'd like to use the NOSORT option, but this is where i've
run
> into trouble. Despite the fact that the input data is sorted in PK order,
> I'm never able to build an index using NOSORT - it always reports that
the
> table data is not sorted on pk. This happens even when i use only one
> loader process.
>
> Can anyone suggest a solution??
>
> Mike.
![]() |
![]() |