Re: copy file to a remote server
- From: Tim Hall <tim@xxxxxxxxxxxxxxx>
- To: epipko@xxxxxxxxxxxx
- Date: Fri, 1 Oct 2010 14:40:07 +0100
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
>
Other related posts:
