Home arrow Oracle arrow Upgrading to Oracle Database 10g, concluded

Upgrading to Oracle Database 10g, concluded

Want to upgrade to Oracle Database 10g, but not sure how? Fortunately, there are a number of ways to do it. This article, the second of two parts, describes these methods and guides you as to which one to use, depending on your circumstances. It is excerpted from chapter two of the Oracle Database 10g DBA Handbook, written by Kevin Loney and Bob Bryla (McGraw-Hill/Osborne, 2005; ISBN: 0072231459).

TABLE OF CONTENTS:
  1. Upgrading to Oracle Database 10g, concluded
  2. Performing the Upgrade
  3. Using the Data-Copying Method
  4. After Upgrading
By: McGraw-Hill/Osborne
Rating: starstarstarstarstar / 8
February 02, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Using Export and Import

Export and Import provide you with an indirect method for the upgrade. You can create an Oracle 10g database alongside your existing database and use Export and Import to move data from the old database to the new database. When the movement of the data is complete, you will need to point your applications to connect to the new database instead of the old database. You will also need to update any configuration files, version-specific scripts, and the networking configuration files (tnsnames.ora and listener.ora) to point to the new database.

Export and Import Versions to Use

When you create an Export dump file via the Export utility, that file can be imported into all later releases of Oracle. Export dump files are not backward compatible, so if you ever need to revert to an earlier version of Oracle, you will need to carefully select the version of Export and Import used. The following table shows the versions of the Export and Import executables you should use when going between versions of Oracle:

 

Export From:

Import To:

Use Export Utility For:

Use Import Utility For:

Release 9.2

Release 10.1

Release 9.2

Release 10.1

Release 8.1.7

Release 10.1

Release 8.1.7

Release 10.1

Release 8.0.6

Release 10.1

Release 8.0.6

Release 10.1

Release 7.3.4

Release 10.1

Release 7.3.4

Release 10.1

Release 10.1

Release 8.0.6

Release 8.0.6

Release 8.0.6

Release 10.1

Release 8.1.7

Release 8.1.7

Release 8.1.7

Release 10.1

Release 9.0.1

Release 9.0.1

Release 9.0.1

Release 10.1

Release 9.2

Release 9.2

Release 9.2

Release 10.1

Release 10.1

Release 10.1

Release 10.1

 

Note that when you are exporting in order to downgrade your database release, you should use the older version of the Export utility to minimize compatibility problems. You may still encounter compatibility problems if the newer version of the database uses new features (such as new datatypes) that the old version will not support.



 
 
>>> More Oracle Articles          >>> More By McGraw-Hill/Osborne
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: