SQL*Loader, multiple infiles, multiple tables, one ctl file

From: Raymond Michael Moran <rmoran_at_mason2.gmu.edu>
Date: 2000/02/15
Message-ID: <88cf2s$1s2_at_portal.gmu.edu>#1/1

how do i load multiple infiles into multiple tables using one control file? The documentation only explains how to load one data file into multiple tables or multiple infiles into a single table. In my example, I have:

LOAD DATA

	INFILE pocktyps.csv	DISCARDFILE pocktyps.dis
	REPLACE INTO TABLE pocket_types
	FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
	(
		pocket_type_code RECNUM,
		pocket_type_desc,
		user_id CONSTANT abc,
		datetime_dtm SYSDATE
	)
	INFILE cntcodes.csv DISCARDFILE cntcodes.csv
	REPLACE INTO TABLE count_type_codes
	FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
	{
		count_type_code RECNUM,
		count_type_desc,
		user_id CONSTANT abc,
		datetime_dtm SYSDATE
	}
 
-- 
- RastaMunn!!! <RastaMunn_at_bigfoot.com> - http://www.bigfoot.com/~RastaMunn -
--- [ o_[ o [ --[   [ o [ V [ U [ \|[ \|[ [ [ [ -- Raymond Moran (Ringo) ---
--- [ [ [ [ [-- [[ [[ | [ M [_ _[|\ [|\ [-[-[-[ ----------------------------

--- The only computer geek who can add 1 + 1 and always comes up with 10 --- Received on Tue Feb 15 2000 - 00:00:00 CET