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