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

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

The applicability of some of the migration methods depends on the on-premises database’s database 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 Oracle Database Cloud Service 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 Oracle Database Cloud 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 Oracle Database Cloud Service 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 Oracle Database Cloud 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 Oracle Database Cloud 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 Oracle Database Cloud Service database are compatible.

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

  • Unplugging/Plugging (non-CDB)

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

    You can use the unplug/plug method to migrate an Oracle Database 12c non-CDB database to Oracle Database 12c in the cloud. This method provides a way to consolidate several non-CDB databases into a single Oracle Database 12c CDB on the cloud.

    For the steps this method entails, see Unplugging/Plugging Non-CDB.

  • Remote Cloning (non-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 Cloud Service database have compatible database character sets and national character sets.

    You can use the remote cloning method to copy an Oracle Database 12c non-CDB on-premises database to your Oracle Database 12c database in the cloud.

    For the steps this method entails, see Remote Cloning Non-CDB.

  • 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.