Home » RDBMS Server » Server Utilities » sql*loader
sql*loader [message #513902] Thu, 30 June 2011 01:14 Go to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

HI,

In SQL*LOADER, Data file should be placed always in server or in local system also can we put?
Re: sql*loader [message #513904 is a reply to message #513902] Thu, 30 June 2011 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68038
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In SQL*Loader it is on the system that launches it.

Regards
Michel
Re: sql*loader [message #513909 is a reply to message #513904] Thu, 30 June 2011 01:32 Go to previous messageGo to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

First we will get csv file and this file converted in .dat format.here my doubt is this .dat file should be always in server location or local system?
Next,loader program will pick that file...next process will be going..
Re: sql*loader [message #513913 is a reply to message #513909] Thu, 30 June 2011 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68038
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It should be (accessible) on the machine that executes SQL*Loader.

Regards
Michel

[Updated on: Thu, 30 June 2011 01:49]

Report message to a moderator

Re: sql*loader [message #513919 is a reply to message #513913] Thu, 30 June 2011 02:42 Go to previous messageGo to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

Thanks Michel,
I'm uploading through conc.program.so it should be in server?
Is there any script or program to transfer automatically from local machine to server? If script is there, we will create conc.prog for that and we can shcedule that program.
Re: sql*loader [message #513921 is a reply to message #513919] Thu, 30 June 2011 02:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68038
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know "conc.program.so" (and have no idea of what it is) and to transfer you could use "ftp".

Regards
Michel
Re: sql*loader [message #514000 is a reply to message #513921] Thu, 30 June 2011 11:32 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
With SQL*Loader, the data file does not have to be on the server; It can be on the local client machine. With external tables, the data file must be on the server.
Re: sql*loader [message #515667 is a reply to message #513919] Tue, 12 July 2011 17:39 Go to previous message
rsager
Messages: 17
Registered: June 2011
Location: Sydney, Australia
Junior Member
Hi rajendaroracle...

A question for you...in your reply you mentioned the "conc.program.so"....are you talking about the Concurrent Program as related to Oracle Applications (11i or R12)?

If so, then sqlldr can be found on either the Database tier (in the $ORACLE_HOME/bin) or the Application Tier (under the Tech Stack 10.1.2/bin). I am quite confident that within the Concurrent Manager definition that you can call SQL Loader and process various csv and other data file) and we have called SQL*Plus to process various things as a custom add on to R12.

Warning: this is a custom exercise and Metalink support will be harder to get.
Cheers
Roger
Previous Topic: Checking column value in SQL Loader
Next Topic: POST_TABLE_ACTION in IMPDP
Goto Forum:
  


Current Time: Fri Nov 26 18:19:05 CST 2021