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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: