Re: copy file to a remote server
- From: Darren Darnell <darren@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 2 Oct 2010 15:55:22 -0500
Not block size, but a multiple of 512 blocks.
Per, Oracle® Database PL/SQL Packages and Types Reference 11g Release 2
(11.2)<http://download.oracle.com/docs/cd/E11882_01/appdev.112/e16760/d_ftran.htm#ARPLS095>
Usage Notes
<snip>
Also, the copied file must meet the following requirements:
-
The size of the copied file must be a multiple of 512 bytes.
-
The size of the copied file must be less than or equal to two terabytes.
<snip>
Darren
On Sat, Oct 2, 2010 at 1:17 PM, Vishal Gupta <vishal@xxxxxxxxxxxxxxx> wrote:
> 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>
> http://www.oracle-base.com/articles/10g/FileTransfer10g.php
>
> <http://www.oracle-base.com/articles/10g/FileTransfer10g.php>Darren
>
> On Fri, Oct 1, 2010 at 8:40 AM, Tim Hall < <tim@xxxxxxxxxxxxxxx>
> 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>
>> 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>
>> 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>
>> 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>
>>> Richard.Goulet@xxxxxxxxxxx]
>>> *Sent:* Thursday, September 30, 2010 12:12 PM
>>> *To:* Eugene Pipko; <oracle-l@xxxxxxxxxxxxx>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>oracle-l-bounce@xxxxxxxxxxxxx[mailto:<oracle-l-bounce@xxxxxxxxxxxxx>
>>> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Eugene Pipko
>>> *Sent:* Thursday, September 30, 2010 3:04 PM
>>> *To:* <oracle-l@xxxxxxxxxxxxx>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:
