Oracle Database Discussions

Dear all,

11g on solaris 10.



Dear all,

When loading data using the below :

sqlldr username/password@db control=data.ctl direct=true errors=10000 readsize=1048576 log=databill.log

data loading successful.

but when am speeding up the same and trying to load as below :


sqlldr username/password@db1 control=databill.ctl direct=true errors=10000 Parallel=true bindsize= 5048576 multithreading=true log=databill.log


SQL*Loader-951: Error calling once/load initialization
ORA-26002: Table username.table has index defined upon it.


If I drop index, and run the same it works fine.. is there way I can speed up the insert (append) using the above


sqlldr username/password@db1 control=databill.ctl direct=true errors=10000 Parallel=true bindsize= 5048576 multithreading=true log=databill.log


control file :

UNRECOVERABLE
LOAD DATA
INFILE "databill.dat" "str X'0c'"
BADFILE "databill.bad"
DISCARDFILE "databill.dis"

APPEND
PRESERVE BLANKS
INTO TABLE username.databill_TEST
FIELDS TERMINATED BY X'07' TRAILING NULLCOLS



Thanks


Kai