Ask the Expert

Can I use Oracle FTP for importing data from Oracle 11g into 10g?

I've exported data from Oracle 11g and am trying to import it into Oracle 10g (release 2). I don't know how to use the Oracle 'FTP' -- I am getting errors with an import command on Unix. Could you please describe the steps needed to be performed for importing the data using 'FTP'?

    Requires Free Membership to View

First of all, when exporting from a higher version of Oracle to be imported into a lower version of Oracle, always use the lower version's exp and imp utilities for the export and import operations. If you use the 11g export utility, the resulting dump file will contain information the 10g import utility will not understand. In order to ensure you can import correctly, use the lower version export utility to create a good dump file.

The 'FTP' utility is just for transferring files, most commonly from one server to another. FTP stands for File Transfer Protocol. For information on FTPing files, please refer to this guide on FTP for Beginners.

When FTP'ing dump files, make sure you explicitly use FTP in BINARY mode. You can do this on the command line by typing "bin" and hitting Enter before you use the "put" or "get" command to initiate the transfer.

This was first published in August 2008

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: