合 Different Upgrade Methods For Upgrading Your Database (Doc ID 419550.1)
APPLIES TO:
Oracle Database - Standard Edition - Version 9.2.0.1 to 12.1.0.1 [Release 9.2 to 12.1]
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 19.12.0.0.0 [Release 12.1 to 19]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
GOAL
This note applies to all the database upgrades to 9iR2 and higher.
SOLUTION
The different upgrade methods you can use to upgrade your database to the new Oracle Database 9i release or higher are:
1) AutoUpgrade Tool (Oracle Database 12c Release 2 and higher)
2) Database Upgrade Assistant (DBUA)
3) Manual Upgrade
4) Export/Import
5) Data Copying
6) Golden Gate
1) AutoUpgrade Tool :
AutoUpgrade Tool can be used on upgrading to below Oracle Database releases: