Remote Cloning a PDB
You can use this method only if the on-premises platform is little endian, the on-premises database release is 22.214.171.124 or higher, and the on-premises database and Database service database have compatible database character sets and national character sets.
You can use the remote cloning method to copy a PDB from your on-premises Oracle Database 12c database to a PDB in an Oracle Database 12c database on the Database service.
To migrate an Oracle Database 12c PDB to a PDB in a Database service database deployment using the remote cloning method, you perform these tasks:
On the on-premises database host, invoke SQL*Plus and close the on-premises PDB and then reopen it in
On the Database service compute node, invoke SQL*Plus and create a database link that enables a connection to the on-premises database.
On the Database service compute node, execute the
CREATE PLUGGABLE DATABASEcommand to clone the on-premises PDB.
On the Database 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 PDB back to