Hi
I've taken expdp backup of a schema from my local database.
expdp directory=DATA_PUMP dumpfile=schema1_%U.dmp logfile=schema1.log schemas=schema1 compression=all parallel=3
Now I wish to use these dumpfiles to refresh a schema on a remote database but I do not have space on my remote server to SCP the dumpfiles to it.
So I've added a TNS of my remote database to my local tnsnames.ora and tried the below command from my local server..
impdp system/xxxx@remotedb directory=DATA_PUMP dumpfile=schema1_%U.dmp schemas=schema1 logfile=IMPDP.log parallel=3
Import: Release 11.2.0.4.0 - Production on Mon Jan 14 05:01:47 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name DATA_PUMP is invalid
P.S.I've not created any directory on my remote db of the name DATA_PUMP and have not created any dblinks on my local and remote db ..as in one of the oracle docs it was mentioned that only for using network_link parameter it requires it
Can someone advise what I've missed here..
Thanks a lot for your time..
--- Veera