OraFAQ Forum: SQL & PL/SQL » Is it possible to use UTL_FILE.fopen to open a text file from a server that is not the current serve

Home » SQL & PL/SQL » SQL & PL/SQL » Is it possible to use UTL_FILE.fopen to open a text file from a server that is not the current serve

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

Is it possible to use UTL_FILE.fopen to open a text file from a server that is not the current serve [message #36913]

Thu, 03 January 2002 12:22

N.N.
Messages: 5
Registered: October 2001

Junior Member

I'm trying to read a text file from server A while currently logged onto server B and want to write data from the text file in server A into a table in server B. Anyone every tried this, is it possible?
Thank you in advance.

----------------------------------------------------------------------

Report message to a moderator

Re: Is it possible to use UTL_FILE.fopen to open a text file from a server that is not the current s [message #36915 is a reply to message #36913]

Thu, 03 January 2002 16:23

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

its possible.but directory on server B must be shared and mapped in server A.
one more thing you need to change oracle service and tnslistener configuration..
goto "logon as" tab of oracle service properties and choose "this account", enter domain
user account information..

do samething for tns listener service.

HTH
SURESH

----------------------------------------------------------------------

Report message to a moderator

Re: Is it possible to use UTL_FILE.fopen to open a text file from a server that is not the current s [message #39634 is a reply to message #36913]

Tue, 30 July 2002 03:21

SEMANTICA
Messages: 9
Registered: July 2002

Junior Member

You can use PL/File to operate on local and remote files, directories and zip files. PL/File allows you to use PL/SQL calls to access these objects through the PLFILE package. No remote Oracle software is needed. You can download a free trial at www.plfile.com.

SEMANTICA

Sales team

Report message to a moderator

Previous Topic:	Performance Tuning
Next Topic:	can i execute the sqlldr from inside the plsql procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 23:08:46 CDT 2024