SQL*Loader - curious
From: Karim Makhani <karim_at_cs.UAlberta.CA>
Date: Tue, 17 Aug 1993 17:06:29 GMT
Message-ID: <1993Aug17.170629.22414_at_cs.UAlberta.CA>
Date: Tue, 17 Aug 1993 17:06:29 GMT
Message-ID: <1993Aug17.170629.22414_at_cs.UAlberta.CA>
Hi.
I have a few questions on SQL*Loader 7.0.12.1.0.
I was trying to read two data files into two different database tables all from a single control file. This is not important - but rather an experiment to see how this can be done? The SQL*Loader portion of the utilities manual suggests that this can be done, but I failed to get this to work?
My control file looks like the following:
LOAD DATA
INFILE 'data/course.dat' BADFILE 'course.bad' DISCARDFILE 'course.dsc'
INFILE 'data/complete.dat' BADFILE 'complete.bad' DISCARDFILE 'complete.dsc'
REPLACE
INTO TABLE course
FIELDS TERMINATED BY ";" OPTIONALLY ENCLOSED BY '"'
(c_code,
c_desc,
c_maxen integer external,
c_iid,
c_pcode )
INTO TABLE completed
FIELDS TERMINATED BY ";" OPTIONALLY ENCLOSED BY '"'
(s_id,
c_code,
c_date DATE "DD-Mon-YY",
c_grade )
Is it at all possible, or do I have to create a control file for each data file that needs to be read in?
Please email any suggestions to: karim_at_cs.ualberta.ca
Thanks in advance.
Karim.
Received on Tue Aug 17 1993 - 19:06:29 CEST
