Home » RDBMS Server » Server Utilities » SQL Loader multiple infiles in single control file
SQL Loader multiple infiles in single control file [message #74712] Mon, 07 February 2005 11:28 Go to next message
Tony
Messages: 190
Registered: June 2001
Senior Member
Hi,
I have a control file established for each infile.
ex:

load data
infile 'load_multum_unit.txt'
append into table temp_multum_unit
fields terminated by ";" optionally enclosed by '"'
(
M_UNIT_ID,
ABBREVIATION,
DESCRIPTION
)

Can I specify multiple infiles in the same control file even though the data in each infile is for a different table?
ex:

load data
infile 'load_multum_unit.txt'
append into table temp_multum_unit
fields terminated by ";" optionally enclosed by '"'
(
M_UNIT_ID,
ABBREVIATION,
DESCRIPTION
)

load data
infile 'load_multum_clinical_route.txt'
append into table temp_m_clinical_route
fields terminated by ";" optionally enclosed by '"'
(
ROUTE_CODE,
ROUTE_DESC
)

Thanks!!

Report message to a moderator

Re: SQL Loader multiple infiles in single control file [message #74718 is a reply to message #74712] Tue, 08 February 2005 04:09 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

No, anyway, not like you want to do it. You can only have one "LOAD DATA" clause per controlfile.

Nevertheless, you can specify several "INFILE" and "INTO TABLE" clauses.

For details, look at the Oracle Utilities Users Guide.

Best regards.

Frank

Report message to a moderator

Previous Topic: Import without Create table privilege
Next Topic: sql loader-925
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 01:17:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.