Home » Applications » Oracle Fusion Apps & E-Business Suite » How can we upload the data from more than one dat files thru SQL* Loader utility.
How can we upload the data from more than one dat files thru SQL* Loader utility. [message #148804] Mon, 28 November 2005 04:49 Go to next message
amit_pbt
Messages: 6
Registered: October 2005
Junior Member
How can we upload the data from more than one dat files thru SQL* Loader utility?

Regards,
Amit.

Report message to a moderator

Re: How can we upload the data from more than one dat files thru SQL* Loader utility. [message #150193 is a reply to message #148804] Tue, 06 December 2005 13:03 Go to previous messageGo to next message
toyway
Messages: 32
Registered: July 2002
Member
You may use Perl to write script which will construct SQL*LOADR command string using different source files (dat files in your case) and run it.

~ Oleg

Report message to a moderator

Re: How can we upload the data from more than one dat files thru SQL* Loader utility. [message #150232 is a reply to message #148804] Tue, 06 December 2005 18:41 Go to previous messageGo to next message
manikoduru
Messages: 1
Registered: December 2005
Location: CA, USA
Junior Member
Amit,

we can load data from multiple files of different types to one or more tables. To specify multiple data files for a single run, use multiple INFILE statements in control file.

Example:

load data -- Loading data from multiple files
infile infile1.dat
infile infile2.dat
-- more specifications

Thanks
Mani

Report message to a moderator

Re: How can we upload the data from more than one dat files thru SQL* Loader utility. [message #150317 is a reply to message #150232] Wed, 07 December 2005 05:03 Go to previous message
amit_pbt
Messages: 6
Registered: October 2005
Junior Member
Hi Mani,

I will try with the code and revert back to u if it gets done.

Anyway thanks for ur assistance.

Rgds,
amit

Report message to a moderator

Previous Topic: Cannot be logged in as GUEST
Next Topic: How pa_tasks table is related with per_all_people_f table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 10 01:46:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.