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

Will 9i exp backup file work on 8i?

We have one exp backup file in Oracle 9i and wonder whether it will work in Oracle 8i. If not, what changes do we have to do? We have to store some tables with data from 9i to 8i.
The dump file may not work. The rule of thumb when going from a higher version to a lower version is to use the lower version's export and import utilities. You may have some success in importing as it currently stands, but you may run into problems. The only way to know for sure is to try it. If it doesn't work, then re-export with the 8i utility. It will import into the 8i database just fine.

Dig Deeper on Oracle database design and architecture

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