Re: copy file to a remote server
- From: Frits Hoogland <frits.hoogland@xxxxxxxxx>
- To: andy@xxxxxxxxxxxxxxx
- Date: Fri, 1 Oct 2010 15:47:37 +0200
See this blogpost: Using datapump on windows to write to a share
Frits Hoogland
http://fritshoogland.wordpress.com
mailto: frits.hoogland@xxxxxxxxx
cell: +31-6-53569942
On Oct 1, 2010, at 3:27 PM, Andy Klock wrote:
> Back in my utl_file_dir/Windows days I remember having issues with accessing
> mapped drives (typically resolved with lots of rebooting). You may be better
> off with Oracle Directories.
>
> Or another approach is to convert the file into a clob and then having a
> program convert it to a file. To give Cary Millsap a plug, his Mr. Trace SQL
> Developer pluggin works under this premise to deliver developers server side
> trace information, giving them the tools to think for themselves.
>
> To start convert your file into a clob:
>
> --uncompiled pseudo-code
> create or replace function getmyfile (p_directory varchar2, p_filename
> varchar2) return clob as
> c clob;
> b bfile := bfilename(p_directory,p_filename);
> begin
> dbms_lob.open(b,dbms_lob.file_readonly);
> dbms_lob.createtemporary(c,true);
> dbms_lob.loadfromfile(c,b,dbms_lob.lobmaxsize);
> dbms_lob.close(b);
>
> return c;
>
> end getmyfile;
> /
>
> Then you could use a program to dump that clob to a file someplace (that's
> not restricted to an Oracle directory). I would use Java whereas Jared would
> probably use Perl.
>
> Another option could be to call an Oracle scheduled job that kicks off a bat
> script or xcopy directly to do this file copy.
>
> On Thu, Sep 30, 2010 at 5: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.
>
>
Other related posts:
