SQL & PL/SQL

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!

Importing a dump file with DBMS_DATAPUMP into a different database

571956Mar 27 2009 — edited Mar 27 2009

Can I import a dump file using the DBMS_DATAPUMP procedure from one database to another? I know within the OPEN subprocedure you can specify a database link, but that requires the dump file be located on the server where that database link is pointing to.

What I want to do is leave the dump file on Server A and import it into Server B....can I do that? Or do I have to physically move the file out to Server B?

Thanks for your help!

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2009

Added on Mar 27 2009

2 comments

501 views