Goal
We will take a tablespace named FOR TRAVEL for migrate it into a PDB situated in your Europe Cloud in extreme performance database.
This migration will be executed with Data Pump and transportable tablespace method. We will migrate the tablespace “FOR_TRAVEL” with a table from Windows Oracle 11g database to Linux Oracle 12c PDB Database.
On-Premise Database
You must have :
A directory and permissions :
Operactions
Let’s take our BACKUP_DIR directory for the migration on Premise.
Let’s put the tablespace to migrate Read Only :
Outside of SQLPLUS let’s launch Data Pump command
Preparing the migration
Copying datafile and dump file from 11g Oracle database to 12c Oracle Database in Cloud instance
Verifying the directory on 12c Oracle Database in Cloud instance
Our import directory will be DATA_PUMP_EXP
Copying
For the copy we used SCP command without a private key SSH because we have our tunnel SSH already started
Importing into PBD1
Before to import make sure your user is created in the PDB. It’s the same user than in your on-premise database.
Importing Dump file
Once the import is complete we pass the FOR_TRAVEL tablespace in read write mode
Verifying the migration
It’s very easy to migrate your tablespace from windows on-premise to your 12c cloud pluggable database.