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 #231446]

Tue, 17 April 2007 02:20

ritikaindu
Messages: 30
Registered: March 2007
Location: asas

Member

Hi All

Can we place our control file on a server(server 1) other than the one(server 2) where we want to insert data and use sql*loader from server 1 to load data into table in server 2 .(server 1 has Oracle 9i and server 2 has oracle 10g).

Report message to a moderator

Re: sql * loader [message #231532 is a reply to message #231446]

Tue, 17 April 2007 07:22

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Are you talking about sql*loader control file?
It is just a client side file. Controlfile will need to ***see*** the datafile to be loaded.
So, nfs mount the remote datafile if you want.

Report message to a moderator

Re: sql * loader [message #231725 is a reply to message #231532]

Wed, 18 April 2007 04:50

ritikaindu
Messages: 30
Registered: March 2007
Location: asas

Member

Hi Mahesh
Thanks i have been able to solve my problem.But another thing i would like to ask is about calling sql*loader utility inside a stored procedure.Is it possible and how?
Thanks
Ritika

Report message to a moderator

Re: sql * loader [message #231729 is a reply to message #231725]

Wed, 18 April 2007 04:54

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Don't use SQL*Loader use external table.

Regards
Michel

Report message to a moderator

Re: sql * loader [message #231738 is a reply to message #231725]

Wed, 18 April 2007 05:12

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Is it possible and how?
Yes. You should use Java or OCI.
Save yourself from the pain and use external tables~

Report message to a moderator

Previous Topic:	Equivalent of "VBCRLF" in SQL Plus?
Next Topic:	SQL Loader and dates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 14:04:09 CDT 2024