Database Utilities (MOSC)

MOSC Banner

Import datapump error - ORA-12154 when using a network_link parameter

edited Apr 2, 2013 7:44AM in Database Utilities (MOSC) 4 commentsAnswered ✓
Hello,

I'm receiving the following stack trace after running a datapump import job with the following parameters:

userid=system
network_link=etsprod_10g.world
full=y

The stacktrace is below:

ORA-39001: invalid argument value
ORA-39200: Link name "etsprod_10g.world" is invalid.
ORA-12154: TNS:could not resolve the connect identifier specified

I created the database link as public and the type setup is current user:

create public database link etsprod_10g.world connect to system identified by <password> using 'etsprod_10g.world';

I then performed a select * from dual@etsprod_10g.world to confirm the link is functional:

SQL> select count(*) from

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