I want to take the back up of my local Oracle instance and want it to import on my remote server.
I have searched the web but couldn't find any solution. The solution I got is:
But my requirement is:
I have a schema in my local oracle instance. Now I want to take it's backup and import it on to my remote server.
Below are commands I am running for exporting and importing.
for Local--
expdp HR/HR@ORCL directory=Export SCHEMAS=MUKESH DUMPFILE=MUKESH.dmp LOGFILE=MUKESH.log
impdp HR/HR@ORCL directory=Export SCHEMAS=MUKESH DUMPFILE=MUKESH.dmp LOGFILE=MUKESH.log
for Remote--
expdp FASTAdmin/[email protected]:1521/ORCL network_link=to_rds directory=Data_pump_dir dumpfile=MUKESH.dmp logfile=MUKESH.log SCHEMAS='MUKESH'
impdp FASTAdmin/[email protected]:1521/ORCL directory=DATA_PUMP_DIR dumpfile=MUKESH.dmp logfile=MUKESH.log SCHEMAS=MUKESH
Note:Please give me the solution using expdp and impdp command only.
Three simple steps:
DATA_PUMP_DIR
In step 2, if you don't know the directory, you could do:
SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR';
See an example here.