Migrating from Oracle Database 12c CDB to Oracle Database 12c in the Cloud

You can migrate Oracle Database 12c CDB databases from on-premises to Oracle Database 12c databases in the Oracle Cloud Infrastructure Database service using several different methods.

The applicability of some of the migration methods depends on the on-premises database's character set and platform endian format.

If you have not already done so, determine the database character set of your on-premises database, and determine the endian format of the platform your on-premises database resides on. Use this information to help you choose an appropriate method.

  • Data Pump Conventional Export/Import

    This method can be used regardless of the endian format and database character set of the on-premises database.

    For the steps this method entails, see Data Pump Conventional Export/Import.

  • Data Pump Transportable Tablespace

    This method can be used only if the on-premises platform is little endian, and the database character sets of your on-premises database and the Database database are compatible.

    For the steps this method entails, see Data Pump Transportable Tablespace.

  • RMAN Transportable Tablespace with Data Pump

    This method can be used only if the on-premises platform is little endian, and the database character sets of your on-premises database and the Oracle Cloud Infrastructure Database service database are compatible.

    For the steps this method entails, see RMAN Transportable Tablespace with Data Pump.

  • RMAN CONVERT Transportable Tablespace with Data Pump

    This method can be used only if the database character sets of your on-premises database and the Database database are compatible.

    This method is similar to the Data Pump Transportable Tablespace method, with the addition of the RMAN CONVERT command to enable transport between platforms with different endianness. Query V$TRANSPORTABLE_PLATFORM to determine if the on-premises database platform supports cross-platform tablespace transport and to determine the endian format of the platform. The Database service platform is little-endian format.

    For the steps this method entails, see RMAN CONVERT Transportable Tablespace with Data Pump.

  • RMAN Cross-Platform Transportable Tablespace Backup Sets

    This method can be used only if the database character sets of your on-premises database and the Database service database are compatible.

    For the steps this method entails, see RMAN Cross-Platform Transportable Tablespace Backup Sets.

  • Data Pump Full Transportable

    This method can be used only if the database character sets of your on-premises database and the Database service database are compatible.

    For the steps this method entails, see Data Pump Full Transportable.

  • Unplugging/Plugging (CDB)

    This method can be used only if the on-premises platform is little endian, and the on-premises database and Database database have compatible database character sets and national character sets.

    For the steps this method entails, see Unplugging/Plugging a PDB.

  • Remote Cloning (CDB)

    This method can be used only if the on-premises platform is little endian, the on-premises database release is 12.1.0.2 or higher, and the on-premises database and Database service database have compatible database character sets and national character sets.

    For the steps this method entails, see Remote Cloning a PDB.

  • RMAN Cross-Platform Transportable PDB

    This method can be used only if the on-premises platform is little endian, and the database character sets of your on-premises database and the Database service database are compatible.

    For the steps this method entails, see RMAN Cross-Platform Transportable PDB.

  • SQL Developer and SQL*Loader to Migrate Selected Objects

    You can use SQL Developer to create a cart into which you add selected objects to be loaded into your Oracle Database 12c database on the cloud. In this method, you use SQL*Loader to load the data into your cloud database.

    For the steps this method entails, see SQL Developer and SQL*Loader to Migrate Selected Objects.

  • SQL Developer and INSERT Statements to Migrate Selected Objects

    You can use SQL Developer to create a cart into which you add selected objects to be loaded into your Oracle Database 12c database on the cloud. In this method, you use SQL INSERT statements to load the data into your cloud database.

    For the steps this method entails, see SQL Developer and INSERT Statements to Migrate Selected Objects.