Q

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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close