-
Passing parameters to control file
Hi,
I have to load some ten csv files to 10 different tables in a particular schema say TEST. Is there any way to automate it, instead of writing 10 different control files for each pair of CSV file and table.?
I am using sqlldr to load the tables.
sqlldr $usrpass $ctlfile log=$logfile bad=$badfile data=$datfile discard=$dscfile
Kindly help me in this regard.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|