Database Administration (MOSC)

MOSC Banner

dblink issue.

edited Jun 18, 2018 11:35AM in Database Administration (MOSC) 4 comments
Hello DBAs..

I createde  a db link in dev env to copy some tables from prod whenever need. while i am teting i am getting below error. please help me to fix this..

create public database link ptprd.world using 'ptp.world';

create database link ptpda.world connect to nbkeqeo identified by xxxx using 'PTP.WORLD';

OWNER           DB_LINK            USERNAME             HOST
--------------- ------------------ -------------------- --------------------
NBKEQEO         PTPDA.WORLD        NBKEQEO              PTP.WORLD
PUBLIC          PTPRD.WORLD                             ptp.world

SQL> select * from dual@PTPDA.WORLD;
select * from dual@PTPDA.WORLD
                   *
ERROR at line 1:
ORA-02019: connection description for remote database not found


SQL> select * 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