RE: copy file to a remote server

  • From: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
  • To: <darren@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 3 Oct 2010 13:21:36 +0100

Darren,

 

yes you are right. My memory did not serve me well there. I just seemed
to remember that I faced an issue with file size with
DBMS_FILE_TRANSFER. But forgot that it was with filesytem block size
rather than db block size. 

 

Vishal

 

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Darren Darnell
Sent: 02 October 2010 21:55
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: copy file to a remote server

 

Not block size, but a multiple of 512 blocks.

 

Per, Oracle(r) 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





 

Other related posts: