Upgrade and or Migrate Your Database

Upgrading your Oracle Database provides the latest in efficient, reliable, secure data management for mission-critical on-line transaction processing applications, query-intensive data warehouses, and cloud applications. With the right planning, preparation, and steps, the upgrade process will be simpler, faster, and more predictable from start to finish. Learn more about upgrading to Oracle Database 18c (& Oracle Database 12c) by exploring resources, documentation and more. Get an overview of various methods that may be used to upgrade Oracle Database.

Get the Details

Database Compatibility Matrix

Wondering which prior releases are supported for direct upgrade to the latest Oracle Database releases? Check out the Database Server Upgrade/Downgrade Compatibility Matrix.

Database Upgrades

Planning a manual upgrade of a non-CDB database? The Complete Checklist for Manual Upgrades to Non-CDB Oracle Database (Doc ID 2173141.1) provides a check list for review prior to performing a manual upgrade.

Upgrading a multitenant container database? The Complete checklist for Manual Upgrade for Multtienant Architecture Oracle Databases (Doc ID 2173144.1) provides a check list for all of the steps involved in upgrading a CDB.

Using the Database Upgrade Assistant (DBUA) to perform your upgrade of a non-CDB? The Complete Checklist for Upgrading to Oracle Database using DBUA (Doc ID 2189854.1) provides a check list for review prior to performing an automated upgrade.

Using DBUA to upgrade a multitenant container database? The Complete Checklist for Upgrading Oracle Container Database (CDB) to Oracle Database using DBUA (Doc ID 2240413.1) provides a check list for review.

Database Migrations

Oracle Data Pump provides high-speed, parallel Export and Import for data and metadata movement between Oracle databases. The What's New in Oracle Data Pump presentation delivered at Oracle OpenWorld discusses the new features of Oracle Data Pump in Oracle Database 12c Release 2. Make migrating and consolidating faster and easier by using the Oracle Data Pump: Full Transportable Export/Import feature. It combines the ease of use of Data Pump with the speed of transportable tablespaces.

Loading Data into Oracle

Perform high-speed data filtering and loading from external files into Oracle database tables using the SQL*Loader feature of Oracle Database. The Express Mode Loading with SQL*Loader in Oracle Database white paper discusses how Express Mode can simplify loading data from files into Oracle Database.

External Tables allows you to access data in external sources as if it were a table inside the database. External tables can be accessed from SQL, PL/SQL and by embedded SQL in other programming languages.