Q
Problem solve Get help with specific problems with your technologies, process and projects.

Dumping data from 10g to 9i

How to dump data from Oracle 10g to Oracle 9i? Or, how to move the dump from a 10g database to a 9i database?

How to dump data from Oracle 10g to Oracle 9i? Or, how to move the dump from a 10g database to a 9i database? Thanks in advance.
Because you are attempting to get data from Oracle 10g to 9i, you have two choices. You can use the export and import utilities, or you can create a database link from the 9i database to the 10g database and pull the data through that way. Export/import is usually more efficient. The trick here is that to export data from Oracle 10g, you will have to use an Oracle 9i exp binary to do it; otherwise, when you try to import into the 9i database, it will not be successful. You must always use a version of the export utility that is equal to the lowest version of either the source or the target database. If you have access to Metalink, there is a very useful article that explains the compatibility of export/import between different versions (Doc ID #132904.1).

Dig Deeper on Oracle database installation, upgrades and patches

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close