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

Home -> Community -> Mailing Lists -> Oracle-L -> CAN A CTL file CONTAIN SEVERAL INFILE

CAN A CTL file CONTAIN SEVERAL INFILE

From: grace lim <mglim_at_softhome.net>
Date: Tue, 07 Nov 2000 12:16:28 +0800
Message-Id: <10672.121270@fatcity.com>


GURUS, CAN one CTL CONTAIN SEVERAL INFILES?
IS THE CTL FILE I MADE CORRECT? IF NOT , what's the correct way of doing it? i' m getting this error when the sql loader: Expecting keyword INTO or end of file, found keyword load. LOAD DATA here's thectl file i made . all of these codes are in 1 ctr file named test.ctl
LOAD DATA
INFILE 'C:\sqlldr\a.ORA' REPLACE
INTO TABLE a_WORK
FIELDS TERMINATED BY '~'
(promo_code)

INFILE 'C:\sqlldr\b.ORA' replace
INTO TABLE b_WORK
FIELDS TERMINATED BY '~'
(promo_code)

Grace Lim
Suy Sing Comm'l Corp. Received on Mon Nov 06 2000 - 22:16:28 CST

Original text of this message

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