Data Pump Conventional Export/Import from OnPrem to OCI Cloud

 Dear All,

In this post i am sharing 

Data Pump Conventional Export/Import from OnPrem to OCI Cloud.

On-Prem # Make Directory

$ mkdir -p /opt/oracle/dump

$sqlplus / as sysdba

SQL> Create directory dpump_dir as '/opt/oracle/dump';

# Perform Export Operation (connecting to your non-cdb database or PDB)

$ expdp system/Oracle321@oracleonprem:1521/onpredb1 schemas=dbatest directory=dpump_dir flashback_time=systimestamp dumpfile=exp_dbatest_schema.dmp logfile=exp_dbatest_schema.log

 

# SCP the Dumpfiles from On-Prem Machine to OCI DB System

Above Export command will create the exp_dbatest_schema.dmp file this you can copy to destination server which is OCI DB system .

 

OCI DB-System Cloud :

 # Make Data Pump Directory

$ mkdir -p /u01/app/oracle/admin/export

SQL> create directory dpump_dir as '/u01/app/oracle/admin/export';

 # Create the tablespace for the destination

SQL> create tablespace dbaltab datafile '+DATA' size 10G;

 # Perform the Import operation

$ impdp system/Oracle786@"Host:port/service_name" SCHEMAS=dbatest DIRECTORY=dpump_dir dumpfile=exp_dbatest_schema.dmp logfile=imp_dbatest.log

Thanks,

Srini