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



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. 




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)

        Usage Notes


        Also, the copied file must meet the following requirements:

        *         The size of the copied file must be a multiple of 512

        *         The size of the copied file must be less than or equal
to two terabytes.





On Sat, Oct 2, 2010 at 1:17 PM, Vishal Gupta <vishal@xxxxxxxxxxxxxxx>

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




Other related posts: