I have a box who's host name was changed to better clarify what it will
do. It has on old public database link that I no longer need.

Below is the commands I ran to drop it:

SQL> select 'drop public database link ' || DB_LINK || '; '
2 from dba_db_links ;

'DROPPUBLICDATABASELINK'||
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------
drop public database link ACCT_GLOBAL;

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

How do I drop it? Or do I not need to worry about when I recreate it?

Any help would be appreciated.

Thanks,

Lawrence Traub, DBA



This message is intended only for the use of the individual(s) or entity to which it is addressed and may contain information that is privileged, confidential, and/or proprietary to RealPage and its affiliated companies. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, forwarding or copying of this communication is prohibited without the express permission of the sender. If you have received this communication in error, please notify the sender immediately and delete the original message.

Oracle LazyDBA home page