Q

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

Database Backup and Recovery expert Brian Peasland explains why the Oracle FTP utility cannot be used 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'?
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

Dig deeper on Oracle database administration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close