Home » Applications » Oracle Fusion Apps & E-Business Suite » How to load data from two different files using single control file to the same table parlally (oracle 10g, )
How to load data from two different files using single control file to the same table parlally [message #564028] Mon, 20 August 2012 10:53 Go to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
Hi All,

I am submitting two programs at a time to load the data from two different files to the same table using same conttol file, but the data is not loading in correct way, please help me how to load data parlally using control file logic.
Re: How to load data from two different files using single control file to the same table parlally [message #564029 is a reply to message #564028] Mon, 20 August 2012 10:55 Go to previous messageGo to next message
Michel Cadot
Messages: 59794
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
118 posts and you don't know you have to post what you did?
How do you expect we tell us what is wrong when you do tell us what you did?

Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: How to load data from two different files using single control file to the same table parlally [message #564031 is a reply to message #564029] Mon, 20 August 2012 11:11 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
Extremely sorry, i am in hurry...to fix this

I am not using direct load, i am submitting the concurrent programs to load the data by using oracle applications as the program type as HOST.
this is the logic, i have written in the host file to load the data
sqlldr $1 CONTROL=$CUSTOM_TOP/bin/TEST_IMPORT_CTL.ctl DATA=$Datafilename
Re: How to load data from two different files using single control file to the same table parlally [message #564036 is a reply to message #564031] Mon, 20 August 2012 11:23 Go to previous messageGo to next message
Michel Cadot
Messages: 59794
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You are in hurry and you are wasting your time.
This does not add anything to what you said.
Post the control file.
Post the table.
Post an extract of the data files.
Post the execution of the loader sessions.

And we still don't know your Oracle version.

Regards
Michel
Re: How to load data from two different files using single control file to the same table parlally [message #564038 is a reply to message #564036] Mon, 20 August 2012 11:25 Go to previous messageGo to next message
Michel Cadot
Messages: 59794
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ah! I see you use Oracle applications, I'll move the topic to this forum.

Regards
Michel
Re: How to load data from two different files using single control file to the same table parlally [message #564762 is a reply to message #564038] Tue, 28 August 2012 09:02 Go to previous message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Whether it is in oracle apps or normal command it works almost in the same way.
What to you mean by "but the data is not loading in correct way"?

By
Vamsi
Previous Topic: Oracle Financial Modules...............(2 merged by VK)
Next Topic: Error While Running Depreciation in Oracle Fixed Asset
Goto Forum:
  


Current Time: Wed Nov 26 18:26:42 CST 2014

Total time taken to generate the page: 0.05862 seconds