Restoring an Oracle database backup to another version of the database

Picked up a handy little tip.  If you want to move a bunch of data from one Oracle database to another, you can use the exp and imp utilities to dump the data and restore it respectively.

But what if the two databases are different versions?  I wanted to do this recently to copy data from an 11g database into an Oracle XE 10g database on my laptop, so I could take it with me.  But the imp utility that comes with XE can’t restore the data from the dump produced by the exp utility in 11g.

What to do?  Turns out the answer was very easy!  All you have to do is use the lower version to do the dump.  So in this case, create an entry in the tnsnames.ora on the XE database, pointing to the 11g database, and then use the XE (10g) exp utility to dump the 11g database.  This dump can be easily imported into the 10g database.

Simple!

About Mark Nelson

Mark Nelson is an Architect (an "IC6") in the Fusion Middleware Central Development Team at Oracle. Mark's job is to make Fusion Middleware easy to use in the cloud and at home, for developers and operations folks, with special focus on continuous delivery, configuration management and provisioning - making it simple to manage the configuration of complex environments and applications built with Oracle Database, Fusion Middleware and Fusion Applications, on-premise and in the cloud. Before joining this team, Mark was a senior member of the A-Team since 2010, and worked in Sales Consulting at Oracle since 2006 and various roles at IBM since 1994.
This entry was posted in Uncategorized and tagged , . Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s