OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » sql*loader

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

sql*loader [message #513902]

Thu, 30 June 2011 01:14

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?

Report message to a moderator

Re: sql*loader [message #513904 is a reply to message #513902]

Thu, 30 June 2011 01:21

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

Senior Member
Account Moderator

In SQL*Loader it is on the system that launches it.

Regards
Michel

Report message to a moderator

Re: sql*loader [message #513909 is a reply to message #513904]

Thu, 30 June 2011 01:32

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..

Report message to a moderator

Re: sql*loader [message #513913 is a reply to message #513909]

Thu, 30 June 2011 01:49

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

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

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.

Report message to a moderator

Re: sql*loader [message #513921 is a reply to message #513919]

Thu, 30 June 2011 02:50

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

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

Report message to a moderator

Re: sql*loader [message #514000 is a reply to message #513921]

Thu, 30 June 2011 11:32

Barbara Boehmer
Messages: 9102
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.

Report message to a moderator

Re: sql*loader [message #515667 is a reply to message #513919]

Tue, 12 July 2011 17:39

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

Report message to a moderator

Previous Topic:	Checking column value in SQL Loader
Next Topic:	POST_TABLE_ACTION in IMPDP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 01:34:38 CST 2025