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!

expdp remotely

521540Dec 31 2008 — edited Jan 5 2009
Hi ,
I want to to do a remote export,below are the steps i performed.

TEST A(source DB) on AIX
TESTB(Target DB) ON WINDOWS

so this is what i did,I create a database link TEST in TESTB which is connecting to TESTA and a directory in TESTB with name x and below is the my export(datapump) parfile.

USERid=system/xxx@TESTA
directory=x
network_link=TEST
schemas=a,b,c
dumpfile=abc.dmp
logfile=abc.log
content=all
exclude=statistics

On TESTB:expdp parfile=xx.par

Am i doing right ?does this work between cross platform?if so,can anyone please let me know what am i doing wrong as i got an below error,when the directory actually exist .

ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name x is invalid

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2009
Added on Dec 31 2008
6 comments
1,917 views