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

From: Raymond Michael Moran <rmoran_at_mason2.gmu.edu>
Date: 22 Feb 2000 22:33:17 GMT
Message-ID: <88v2rd$9kq_at_portal.gmu.edu>

I've posted this before but unfortunately I never followed up for an answer. Therefore, I'll ask again. My question is this:

Is it possible to sqlload multiple files into multiple tables using one .ctl file?

The Oracle8 documentation illustrates sqlloading multiple files into one table, or one file into multiple tables. But my work-around for my above question is to create multiple .ctl files and execute them with a batch file as such:

given: foo1.ctl, foo1.csv, foo2.ctl, foo2.csv, foo3.ctl, foo3.csv work-around:

        rem FILE: foo.bat

	rem load table foo1
	sqlload userid=user/pw control=foo1.ctl
	rem load table foo2
	sqlload userid=user/pw control=foo2.ctl
	rem load table foo3
	sqlload userid=user/pw control=foo3.ctl

how would i write foo.ctl, given foo1.csv, foo2.csv, foo3.csv to accomplish the same task (thus eliminating the need for a batch file)?

-- 
- 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 22 2000 - 23:33:17 CET