Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader parallel load sort order

Re: SQL*Loader parallel load sort order

From: Bob <pruder_at_gatorbait.com>
Date: 1997/08/18
Message-ID: <01bcac17$8e48eb20$100000be@fs>#1/1

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>...

> 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.
Received on Mon Aug 18 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US