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
hfbm2004
Messages: 8
Registered: November 2005
Junior Member
Hi,

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

Habib

[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: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
All going into same table?
Previous Topic: perl and Oracle 9
Next Topic: Oracle 9i to Oracle 9i without using imp or exp utility
Goto Forum:
  


Current Time: Fri Dec 09 23:08:21 CST 2016

Total time taken to generate the page: 0.08431 seconds