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?

    Requires Free Membership to View

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 first published in January 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.