RE: copy file to a remote server
- From: "Kenneth Naim" <kennethnaim@xxxxxxxxx>
- To: <epipko@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 1 Oct 2010 09:48:36 -0400
I have utl_file write the file directly to the remote server, rather than
trying to move it. The key is to use the fully qualified unc path
(//server_name//drive/folder1/folder2/file_name.txt) as mapped drives are
generally not seen by oracle since it is started up by a service and mapped
drives are user dependent.
Ken
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Eugene Pipko
Sent: Thursday, September 30, 2010 3:04 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: copy file to a remote server
Hi all,
I am trying to move a .txt file generated by the d/b procedure (9i) to a
remote box. Both servers are windows machines.
Source is 2003 and dest is 2008.
I mapped the drive on source and using utl_file.fcopy, but receiving an
error.
My question is: is it even possible to move a file via utl_file package
between two servers?
Thanks,
Eugene
Other related posts:
