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?
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.