OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How to load data from two different files using single control file to the same table parlally

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, )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Ah! I see you use Oracle applications, I'll move the topic to this forum.

Regards
Michel

Report message to a moderator

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

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 17:53:33 CST 2024