| Easy Solution [message #70318] |
Fri, 24 May 2002 02:52 |
hansolo
Messages: 1
Registered: May 2002
|
Junior Member |
|
|
This is a nice easy solution so long as you know how to write a unix shell script(if you dont then youre crap).
Create a ctl file called default.ctl (or whatever).
In this file instead of specifying
"INFILE 'datafile.dat'" (or whatever) just have
"MYINFILE".
Then instead of specifying "TABLE atable" (or whatever) just have "MYTABLE".
Then in your script (unix csh or ksh) copy the default.ctl file to another filename.ctl
With filename.ctl do a "sed" (replace) on "MYINFILE" and change it to "INFILE 'infile.dat'". Do the same with "MYTABLE" to "TABLE atable".
Then call sqlldr ad pass in filename.ctl
Easy hey.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
