Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Loader Parallel Load

542647Feb 2 2010 — edited Sep 28 2013

Hi,

I am trying to apply parallel load on my ctl file. I have done the google also for same and found that while running sqlloader we need to set Parallel = true as paprameter. and some other parameters to be set like direct = true and unrecoverable in ctl file. but i fell I need to implement following command also for parallel load.

/*+ PARALLEL(emp,4) */

So can anyone help me how should I apply this. Below is my sample CTL file.

OPTIONS (DIRECT=TRUE,ERRORS=9999)
--OPTIONS (DIRECT=FALSE,ERRORS=9999)
UNRECOVERABLE 
LOAD DATA
INFILE '/shared/export/prfl1.dat'
INFILE '/shared/export/prfl2.dat'
INFILE '/shared/export/prfl3.dat'
INFILE '/shared/export/prfl4.dat'
INFILE '/shared/export/prfl5.dat'
INFILE '/shared/export/prfl6.dat'
INFILE '/shared/export/prfl7.dat'
INFILE '/shared/export/prfl8.dat'
INFILE '/shared/export/prfl9.dat'
INTO TABLE L_Cust_Detail
(CUST_ACCT_ID                  POSITION(01:10)   CHAR  "LTRIM(:CUST_ACCT_ID,0)",
ITEM_NUM                       POSITION(22:28)   CHAR,
CUST_ITEM_DEPT_ID              POSITION(29:38)  CHAR,
CUST_ITEM_NUM                  POSITION(39:50) CHAR
)