Database Administration (MOSC)

MOSC Banner

impdp via DB Link Issue

edited Apr 21, 2014 12:42PM in Database Administration (MOSC) 6 commentsAnswered ✓

Greetings -

I created a Dblink successfully,  but when I tried to import data remotely, I was getting the error message below. Could someone assist please.

I can access the DB remotely Ok !

SQL> select sysdate from dual@TO_RDS;

SYSDATE

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

17-APR-14

But I can't run impdp remotely:

[oracle@ip-10-92-51-10 admin]$ impdp RDSUSER/passw@TO_RDS

Import: Release 11.2.0.4.0 - Production on Thu Apr 17 18:53:13 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

UDI-12154: operation generated ORACLE error 12154

ORA-12154: TNS:could not resolve the connect identifier specified

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