expdp from remote database
748245Nov 26 2010 — edited Nov 26 2010Hi Group,
I have two servers :
SERVER1 (PROD) (10G)
SERVER2 (TEST) (11G)
I need to execute expdp and generate an export file in SERVER2 with data from SERVER1, I've tried at first to execute like this:
expdp system@server1 schemas=EULDNPP directory=TEST dumpfile=expdp_EULDNPP.dmp logfile=expdp_EULDNPP.log
but on server1 there is no directory TEST, even it exist
the file would be generate on server1 which I can not access.
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name TEST is invalid
How could I generate the dump file on server2 where I'm executing expdp.
Thanks a lot.
Edited by: user12003066 on 26-nov-2010 10:44