Skip to Content
Author's profile photo Patricia Eidelwein

Upgrade Methods for Upgrading to Oracle Database 11g Release 2

  • Database Upgrade Assistant (DBUA)
  • Manual Upgrade
  • Oracle Data Pump Export
  • Standard Import / Original Export and Import
  • Oracle Transportable Tablespaces
  • Oracle Data Guard SQL Apply (Logical Standby)

Each method has its pros and cons, which are described in detail in the Oracle White paper 486336 (

For low and medium important Databases, the DBUA is a good option to consider using as the first choice. Data Pump is better than the old import / export because it is faster and it can be parallelized.

For critical Databases, Export / Import using Datapump is the safest and most conservative. A copy of the original DB will be exported and imported into a new oracle home.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo James Zhang
      James Zhang

      Hi Daniel,

      Thanks for the sharing.