Maybe it's a public link. Try:

drop public database link FSPRD;

Israel.

Yang Yanyan (JSC-OH230)[ARES] escribió:

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