You can use this method 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 a PDB in an Oracle Database 12c database on an Oracle Database Cloud Service database deployment. This method provides a way to consolidate several non-CDB databases into a single Oracle Database 12c multitenant database on Database Cloud Service.
To migrate an Oracle Database 12c non-CDB database to the Oracle Database 12c database on a Database Cloud Service database deployment using the plug/unplug method, you perform these tasks:
On the on-premises database host, invoke SQL*Plus and set the on-premises database to
On the on-premises database host, execute the
DBMS_PDB.DESCRIBEprocedure to generate an XML file containing the list of datafiles that will be plugged in on the cloud database.
Use a secure copy utility to transfer the XML file and the datafiles to the Database Cloud Service compute node.
On the Database Cloud Service compute node, invoke SQL*Plus and execute the
CREATE PLUGGABLE DATABASEcommand to plug the database into the CDB.
On the Database Cloud Service compute node, execute the
$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sqlscript to delete unnecessary metadata from the
SYSTEMtablespace of the new PDB.
On the Database Cloud Service compute node, open the new PDB by executing the
ALTER PLUGGABLE DATABASE OPENcommand.
Optionally, on the on-premises database host invoke SQL*Plus and set the on-premises database back to