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:
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