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 your Oracle Database by exploring resources, documentation and more. Get an overview of various methods that may be used to upgrade Oracle Database.
Wondering which prior releases are supported for direct upgrade to the latest Oracle Database releases? Check out the Database Server Upgrade/Downgrade Compatibility Matrix.
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.
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. 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. Please consider the Best Practices for Oracle Data Pump. If you are migrating or loading data into Oracle Cloud, the following resources can be helpful: Migrate your on-premises Oracle Database into the Oracle Cloud Infrastructure (OCI), Load data into Oracle Autonomous Transaction Processing (ATP) and Load data into Oracle Autonomous Data Warehouse (ADW)
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.