| How to load table by datafile name? [message #63582] |
Mon, 18 October 2004 17:21  |
LEE SHIN YOUNG
Messages: 4
Registered: October 2004
|
Junior Member |
|
|
Hi! How are you? How to load table by datafile name?
For example
if today is 20041015, Read
INFILE 'E:TPD71M$AUD_20041015.txt'
if today is 20041014, Read
INFILE 'E:TPD71M$AUD_20041014.txt'
So,it can be possible? Thank you!!
|
|
|
|
| Re: How to load table by datafile name? [message #63592 is a reply to message #63582] |
Tue, 19 October 2004 07:38  |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
you can build that file dinamically taking the date value from the system value
for example, on unix can do something like:
echo INFILE /'E:/TPD71M/$AUD_ŽdateŽ.txt/' >> file
then, cat file2 >> file
where file2 has the rest of the control file for sqlldr
is it clear?
Best luck
Oracle consultant and remote DBA for hire.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
