Re: Load indexed table via parallel direct load?

From: <decompton_at_worldnet.att.net>
Date: Mon, 19 Jul 1999 16:38:08 GMT
Message-ID: <7mvk9f$s5$1@nnrp1.deja.com>

Could you post your control file along with the entire command you are running?

To run parallel loads, you must have PARALLEL=TRUE specified somewhere. In addition, you have to have and OPTIONS(FILE='datafile in the tablespace you are loading'). Also, there cannot be any indexes on the table you are loading. You must create them after the fact. And finally, you can only append data with this method. No INSERT/Replaces allowed.

thanks,

dave
In article <7mvefn$u9l$1_at_nnrp1.deja.com>, zuot_at_my-deja.com wrote:
> We attempted to load an index table using direct load in PARALLEL:
>
> sqlldr ... sample.ctl data=sample1.dat direct=TRUE &
> sqlldr ... sample.ctl data=sample2.dat direct=TRUE &
>
> In other words, we fired two instances of sqlldr at the same time. The
> error message we got is:
>
> SQL*Loader-908: Unable to lock table <sample> dur to ORACLE error 54.
>
> Does anyone know what is the inheritant reason for this (Oracle
> 7.3.3.5)? Basically how do you leverage both direct and parallelism at
> the same time?
>
> Tao Zuo
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 19 1999 - 11:38:08 CDT