Trouble with DBMS_FILE_TRANSFER is if your source file size is not a multiple of DB block size, then oracle does not like the file and starts complaining. Regards, Vishal On 1 Oct 2010, at 15:11, "Darren Darnell" <darren@xxxxxxxxxxxxxxx> wrote: > Try using DBMS_FILE_TRANSFER. > > http://www.oracle-base.com/articles/10g/FileTransfer10g.php > > Darren > > On Fri, Oct 1, 2010 at 8:40 AM, Tim Hall <tim@xxxxxxxxxxxxxxx> wrote: > Hi. > > On Linux, Oracle doesn't care what the mount point is provided it has > permission to write to it, so UTL_FILE will work fine on any available mount > point. > > Back in the WinNT days UTL file also working on mapped drives, but with the > move to Windows 2000 it stopped. I raised a TAR with Oracle support at the > time and was told this was now a "feature" brought about my a change > Microsoft had made in Windows 2000. I don't work on Windows much if I can > help it, so I don't know if it is still a "feature", but judging by what you > have said it still is. If this is the case you will never be able to access a > mapped drive directly using UTL_FILE. > > Regarding > "http://www.oracle-base.com/articles/8i/ShellCommandsFromPLSQL.php";, there > are a few things to mention. > > 1) It is potentially very dangerous because it gives access to any OS > command/file that the Oracle software owner has access to. So don't use the > wildcard permissions I've used in the article. > > 2) The Oracle JVM has a limited scope to its permissions, in a similar way to > UTL_FILE. The fact someone has mentioned they don't have a problem on Windows > 2003 with it means it hasn't fallen foul of "mapped drives feature" like > UTL_FILE has, but it may not solve every problem you enocunter. > > 3) You could also consider using a specific file-handling API, like > "http://www.oracle-base.com/articles/8i/FileHandlingFromPLSQL.php";. This may > suffer the same fate as UTL_FILE on Windows since the JVM would not be > responsible for the file movement, rather than the shell, so its scoping may > come into play. > > Cheers > > Tim... > > On Thu, Sep 30, 2010 at 10:21 PM, Eugene Pipko <epipko@xxxxxxxxxxxx> wrote: > 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 > > >