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

Restoring Oracle 9i backup in Oracle 8i

We are taking a backup on Oracle 9i but we want to restore it in Oracle 8i -- is it possible?

We are taking a backup on Oracle 9i but we want to restore it in Oracle 8i -- is it possible? Our server is Sun Solaris and the database is Oracle 8i. We are taking the backup through the exp command and restoring the backup through the imp command. How can we restore the database?
It is a very bad idea to restore a 9i database to 8i. The only way to accomplish this is by using export and import (which are my last choices for Oracle backups). But any 9i new features will not be able to be restored to the 8i database. For instance, Oracle 9i introduced Fine Grained Access Control. Oracle 8i does not have this feature and any database objects that use this feature will not be able to be imported into the 8i database.

Why not install Oracle 9i on the restore server?

This was last published in January 2007

Dig Deeper on Oracle database backup and recovery

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.

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

Please create a username to comment.