Database Administration (MOSC)

MOSC Banner

drop public database link problem(very urgent)

edited Oct 16, 2012 3:57AM in Database Administration (MOSC) 17 commentsAnswered
  hi
we have a db link which has been created long ago and it is public databaselink


OWNER                          DB_LINK                                                 USERNAME                       HOST        
------------------------------ ------------------------------------------------------- ------------------------------ ------------ ------------------

PUBLIC                      db1                                                      user01                                          db1   
when i want to drop it i encounter below error


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


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

no mater with what user i try i still get this error.
Please kindly assist.
i also tried changing global db name it did not help

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