RE: copy file to a remote server

  • From: Eugene Pipko <epipko@xxxxxxxxxxxx>
  • To: "'Goulet, Richard'" <Richard.Goulet@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 30 Sep 2010 14:21:43 -0700

They are not directories.
I set utl_file_dir = * on the source box.
I mapped the drive to the destination box.
When I run UTL_FILE.FCOPY (vSource_dir,vSource_file,vDest_dir,vDest_file); I 
get invalid_operation.

From: Goulet, Richard [mailto:Richard.Goulet@xxxxxxxxxxx]
Sent: Thursday, September 30, 2010 12:12 PM
To: Eugene Pipko; oracle-l@xxxxxxxxxxxxx
Subject: RE: copy file to a remote server

What is your location and dest_dir parameters set to?  Are they directory names 
located in all_directories??


Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International


________________________________
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: