ftp and database file being corrupted

[Tony Kim]

Can anyone tell me if an FTP process not related to Orcle database could possibly corrupt a ".dbf" file? Many years ago, I had similar experience of file corruption while doing an independent file transfer via FTP.

Does anyone have any additional info on this?

Thanks in advance.

[Bill McNAMARA_1]

It'd be rare..
Have a look at PHNE_23949, there is not much talk about file corruption.. I would start looking for other networking patches.

Later,
Bill

[John Strang]

Hi Tony,

My immediate thought is that you might be trying to ftp the file as ascii instead of binary.

When at the ftp> prompt type 'bin' to set to binary mode.

HTH,

John

[A. Clay Stephenson]

If by 'not-related' then you mean routine FTP transfers that are not Oracle files then NO. I have used FTP scripts in both shell and Perl for years in an environment that was also running Oracle and have never experienced database corruption.

On the other hand, if you are transferring database files via FTP then I can think of two possible concerns: 1) ASCII rather than BINARY transfers 2) FTP/OS imposed limits on maximum file sizes.