Database Utilities (MOSC)

MOSC Banner

expdp/impdp of database link fails

edited Oct 8, 2009 12:34AM in Database Utilities (MOSC) 4 commentsAnswered
Today I decided to test out Data Pump for moving a database link from one database to another. I can't get past this error.

Has anyone else had success with this?

Here is test from 10.2 to 10.1. The same test going from 10.2 to 10.2 also failed with the same error.

SQL> CONNECT SCOTT/TIGER;

Connected.

SQL>

SQL> create database link   gothere.stl

  2  connect to ampric1 identified by <password> using 'gar.gwd';

Database link created.

SQL> select owner, db_link,host from dba_db_links;

 

OWNER

------------------------------

DB_LINK

-------------------------------------------------------

HOST

-------------------------------------------------------

SCOTT

GOTHERE.STL

gar.gwd

 

d:\oracle\admin\scripts>expdp system schemas=scott include=db_link dumpfile=anne

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center