SQL*Loader with filename as a parameter [message #69623] |
Fri, 08 February 2002 10:52 |
Sebastian Grasteau
Messages: 1 Registered: February 2002
|
Junior Member |
|
|
Hi!
A same file is generated periodicaly and I need to load it into Oracle (under NT). The files are put into a same directory and have a different version number within the file name: For example I receive the file Productv1.dat, and later Productv2.dat, and later Productv3.dat, ...
1- How can I automaticaly load the latest version file?
2- Can I put a filename as a parameter to sql*loader?
Thanks in advance for your help!
Sebastian.
|
|
|
Re: SQL*Loader with filename as a parameter [message #69624 is a reply to message #69623] |
Fri, 08 February 2002 12:05 |
migel
Messages: 4 Registered: February 2002
|
Junior Member |
|
|
We had a smilar case, but used cron to go out
every so often and look for the file in question.
Then kick off a scrip to move it to a common name
that the control file could use.
So use cron or another scheduling tool to
run a scrip that looks for Productv*.dat
and copy/move it to file like "Load_Prodcutv.dat"
and then start sqlldr with control file that has
"Load_Prodctv.dat" defined as the data file.
HTH
|
|
|
|