Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> CAN A CTL file CONTAIN SEVERAL INFILE
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