impdp with network_link option fails due to database link name
Hi all,
I am trying to use impdp with the network link option.
The public database link I have created as follows :-
LV19075@gidwap1 > create public database link odipoc
2 connect to system identified by *********
3 using 'odipoc';
Database link created.
LV19075@gidwap1 > select * from global_name@odipoc;
GLOBAL_NAME
-----------------------------------------------------------------------------
ODIPOC.GROUP.NET
This results in the following :-
LV19075@gidwap1 > select * from dba_db_links;
OWNER
------------------------------
DB_LINK
-----------------------------------------------------------------------------
USERNAME
------------------------------
HOST
-----------------------------------------------------------------------------
CREATED
---------
PUBLIC
ODIPOC.GROUP.NET
SYSTEM
odipoc
30-JAN-14
When attempting the impdp we get the following :-
[oracle@whyluadb52 export]$ impdp schemas=lnd_choice network_link=ODIPOC logfile=impdp_test.log directory=dp_log_export