Database Administration (MOSC)

MOSC Banner

DB Link Drop Issue

edited Oct 20, 2009 9:22PM in Database Administration (MOSC) 8 commentsAnswered
This is driving me crazy...can anyone pls help.

 SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production


SQL> select owner,db_link from dba_db_links;

OWNER           DB_LINK
--------------- --------------------
APPS            APPS_TO_APPS
APPS            EDW_APPS_TO_WH

SQL> show user
USER is "APPS"

SQL>

SQL> drop database link APPS_TO_APPS;
drop database link APPS_TO_APPS
                   *
ERROR at line 1:
ORA-02024: database link not found


SQL> drop database link EDW_APPS_TO_WH;

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