To me it looks like sysadm owns the link. Try this:

DROP DATABASE LINK sysadm.fsprd ;

Or log in as sysadm and drop the link as normal.

Regards,

Lawrence Traub, DBA

-----Original Message-----
From: Yang Yanyan (JSC-OH230)[ARES]
[mailto:oracledba-ezmlmshield-x47775797.[Email address protected]
Sent: Thursday, January 31, 2008 10:52 AM
To: LazyDBA Discussion
Subject: Drop db link

Hello,

Can anyone help on this problem? I am trying to drop a database link and
received the error message.

SQL> sho user
USER is "SYSADM"
SQL> select * from user_db_links;

DB_LINK USERNAME PASSWORD
HOST CREATED
-------------------- ------------------------------
------------------------------ -------------------- ---------
FSPRD SYSADM BLUESKY
FSPRD 12-DEC-05


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

SQL> select * from global_name;

GLOBAL_NAME
------------------------------------------------------------------------
------------------------------------------------

HRPRD.WORLD

SQL> sho parameter global

NAME TYPE VALUE
------------------------------------ -----------
------------------------------
global_context_pool_size string
global_names boolean FALSE


Thanks

Yanyan


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



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