This what I did: Login as the db link owner sysadm and drop the link.

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

Do you think is it something related to the global name? Do I need to
update props$ table for the global name? Any other suggestion?

Thanks
Yanyan

-----Original Message-----
From: Lawrence Traub
[mailto:oracledba-ezmlmshield-x89733185.[Email address protected]
Sent: Thursday, January 31, 2008 11:04 AM
To: LazyDBA Discussion
Subject: RE: Drop db link


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.


---------------------------------------------------------------------
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



Oracle LazyDBA home page