Load indexed table via parallel direct load?

From: <zuot_at_my-deja.com>
Date: Mon, 19 Jul 1999 14:59:11 GMT
Message-ID: <7mvefn$u9l$1@nnrp1.deja.com>

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. Received on Mon Jul 19 1999 - 09:59:11 CDT