Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

expdp from remote database

748245Nov 26 2010 — edited Nov 26 2010
Hi 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
This post has been answered by Levi Pereira on Nov 26 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 24 2010
Added on Nov 26 2010
9 comments
22,720 views