firstname.lastname@example.org file=filenameat the command promt, it throws the error "not a valid file, header failed verification." What could be wrong?
Typically, this happens when you transfer the dump file from one server to another using an ASCII file transfer mechanism. For example, when you use FTP to transfer the file, many FTP utilities will incorrectly assume that the file is a text file and transfer in ASCII mode. The dump file is a binary file. You should explicitly tell your FTP utility that the file is a binary file. The following example shows how to do just that:
- ftp (invoke the 'ftp' command line utility)
- open unix_server.acme.com
- Sign on with username and password.
- bin (this ftp command will force the transfer to be in binary mode)
- get exp.dmp
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading