Home » RDBMS Server » Server Utilities » One Control-File für many Data-Files
One Control-File für many Data-Files [message #193941] Wed, 20 September 2006 01:37 Go to next message
Messages: 8
Registered: November 2005
Junior Member

we load every day 4 CSVs file with 4 different Loader-Control-Files:
file1.csv - > loader1.ctl
file2.csv - > loader2.ctl
file3.csv - > loader3.ctl
file4.csv - > loader4.ctl

file1.csv: field_1;...;field_100;name
file2.csv: field_1;...;field_100;name;city
file3.csv: field_1;...;field_100;name;city;country
file4.csv: field_1;...;field_100;name;city;country;region

The first 100 columns exist in all the 4 CSVs. All CSVs differ only in one or two fields.

Is it possible to load all the CSVs with only one Control-File?

Thenks in advance


[Updated on: Wed, 20 September 2006 01:45]

Report message to a moderator

Re: One Control-File für many Data-Files [message #193986 is a reply to message #193941] Wed, 20 September 2006 05:30 Go to previous message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
All going into same table?
Previous Topic: perl and Oracle 9
Next Topic: import/export
Goto Forum:

Current Time: Wed Aug 23 16:28:06 CDT 2017

Total time taken to generate the page: 0.11293 seconds