Data Pump Conventional Export/Import
This example provides a step-by-step demonstration of the tasks required to migrate a schema from an on-premises Oracle database to an Oracle Database Classic Cloud Service database.
"Data Pump Export Modes" in Oracle Database Utilities for Release 12.2, 12.1 or 11.2.
"Data Pump Import Modes" in Oracle Database Utilities for Release 12.2, 12.1 or 11.2.
Steps :
1. CREATE DIRECTORY Exp_for_cloud AS '/u01/Exp_for_cloud';
2. expdp system SCHEMAS=vishal,vishalbh ,****,**** DIRECTORY=Exp_for_cloud
3. scp –i Your_private_file_name //dump/Exp_for_cloud/expdat.dmp oracle@IP_address_of_your_machin:/u01/Imp_from_prim
on cloud db server
4. CREATE DIRECTORY Imp_from_prim AS '/u01/Imp_from_prim';
5. impdp system SCHEMAS=vishal,vishalbh ,****,**** DIRECTORY=Imp_from_prim
