Re:CAN A CTL file CONTAIN SEVERAL INFILE

From: <dgoulet_at_vicr.com>
Date: Tue, 7 Nov 2000 09:10:25 -0500
Message-Id: <10673.121294@fatcity.com>

Grace,

    This is not a legal/good/viable ctl file for SQL*Loader. Basically you've got two ctl files concatenated together. Since this references two separate tables with two separate data files you need to do it as two separate runs. If you can eliminate the second table, since they appear to have the same format then the following would work:

LOAD DATA
INFILE 'C:\sqlldr\a.ORA'
INFILE 'C:\sqlldr\b.ORA'
APPEND
INTO TABLE a_WORK
FIELDS TERMINATED BY '~'
(promo_code)

Dick Goulet

____________________Reply Separator____________________

Subject: CAN A CTL file CONTAIN SEVERAL INFILE Author: grace lim <mglim_at_softhome.net>
Date: 11/6/00 8:20 PM

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.
247-41-34

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: grace lim
  INET: mglim_at_softhome.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Tue Nov 07 2000 - 08:10:25 CST