Home » SQL & PL/SQL » SQL & PL/SQL » Read/write files from remote server using utl_file in oracle (oracle 11g)
Read/write files from remote server using utl_file in oracle [message #652419] Wed, 08 June 2016 09:34 Go to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
Hi All,

In my situation, Oracle is installed on Unix Server.

So i can create the file directory and can read the files on the unix server using utl_file.fopen function to read/write the files from oracle.

In the same way i want to access the files on the another server, where my oracle was not installed.

Is there any way to read/write the files from the another server?
Re: Read/write files from remote server using utl_file in oracle [message #652420 is a reply to message #652419] Wed, 08 June 2016 09:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
tolupuluri wrote on Wed, 08 June 2016 07:34
Hi All,

In my situation, Oracle is installed on Unix Server.

So i can create the file directory and can read the files on the unix server using utl_file.fopen function to read/write the files from oracle.

In the same way i want to access the files on the another server, where my oracle was not installed.

Is there any way to read/write the files from the another server?

NO, no way.

PL?SQL runs inside DB engine & can only access OS file system that is local to DB Server
Re: Read/write files from remote server using utl_file in oracle [message #652421 is a reply to message #652419] Wed, 08 June 2016 09:45 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
You can do it by mapping a drive on the unix server that will be done by auto mounting a NFS share. Use google to find out how to do it. The mount is done at boot up of the server so it looks like just another volume on the first server.
Re: Read/write files from remote server using utl_file in oracle [message #652422 is a reply to message #652421] Wed, 08 June 2016 09:52 Go to previous message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
Noted, I will search for that on google. Thank you.
Previous Topic: behaviour of to_timestamp and time zones
Next Topic: How To Update Encrypted Password for all user id's using Update Query
Goto Forum:
  


Current Time: Tue Jul 27 20:17:38 CDT 2021