how to call control file [message #181993] |
Wed, 12 July 2006 09:04 |
mape
Messages: 298 Registered: July 2006 Location: Slovakia
|
Senior Member |
|
|
Hi
From this line I call control file load.ctl ->
sqlldr userid=xx/xx@yy control=load.ctl log=xx.log
and load.ctl looks here
LOAD DATA
INFILE '$2_$3_file.txt'
APPEND
INTO TABLE MAPE_$2_$3
FIELDS TERMINATED BY " " OPTIONALLY ENCLOSED BY '"'
(STH)
where $2 and $3 should be a parameters, for exmaple numbers.
But I dont know how to do it?
Thanks for help
[Updated on: Wed, 12 July 2006 09:22] Report message to a moderator
|
|
|
|
|
|
Re: how to call control file [message #182383 is a reply to message #182382] |
Fri, 14 July 2006 08:48 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
The same concept is used to dynaically pass the name of table, input_file_name as a record in table or whatever.
All you need is a template file.
copy the template to workingfile. Replace the values you want.
Load the working file. Discard the working file.
|
|
|