Home » RDBMS Server » Server Utilities » sql loader not loading file (oracle 11g, AIX websphere)
sql loader not loading file [message #661847] Tue, 04 April 2017 02:28 Go to next message
baba_dx
Messages: 3
Registered: April 2017
Junior Member
There is process which loads data from many server using sql loader.
But there is one server which is not picking files using sql loader.
Same issue is resolved temporarily after taking websphere bounce for that day. On next day facing same issue while loading using sql loader.
There is no error on trace file or log file.
sql loader just getting hang and shows need to xyz files.
Re: sql loader not loading file [message #661851 is a reply to message #661847] Tue, 04 April 2017 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

So what do you expect from us?

Re: sql loader not loading file [message #661872 is a reply to message #661851] Wed, 05 April 2017 00:39 Go to previous messageGo to next message
baba_dx
Messages: 3
Registered: April 2017
Junior Member
What are the possible way to sort out this issue, so that sql loader will work on that particular server.
1) Is this issue due to Unix server on which data files are located
2) due server config file.
3) websphere
4) or anything else.

[Updated on: Wed, 05 April 2017 00:46]

Report message to a moderator

Re: sql loader not loading file [message #661873 is a reply to message #661872] Wed, 05 April 2017 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

1) maybe
2) maybe
3) maybe
4) maybe

Realize that you give NO information.

Re: sql loader not loading file [message #661874 is a reply to message #661873] Wed, 05 April 2017 00:50 Go to previous messageGo to next message
baba_dx
Messages: 3
Registered: April 2017
Junior Member
Laughing what info you need?
Re: sql loader not loading file [message #661875 is a reply to message #661874] Wed, 05 April 2017 00:54 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Explain in details your architecture (2-tiers, 3-tiers, n-tiers...)
Explain in details what you do (which command you execute, from what application, from what platform...)
Copy and paste what you do and get when it works.
Copy and paste what you do and get when it does not work.

Before, Please read How to use [code] tags and make your code easier to read.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
(This latest point is important, I do NOT answer to post that is hard to read and hurt my eyes.)

[Updated on: Wed, 05 April 2017 00:55]

Report message to a moderator

Previous Topic: datapump export import
Next Topic: Issue in export
Goto Forum:
  


Current Time: Mon Dec 23 02:23:34 CST 2024