Try this please......should help:


1. sqlplus "/ as sysdba"

2. update props$ set value$ = 'FSPRD' where name ='GLOBAL_DB_NAME';

3. commit work;

4. conn sysadm/password

5. drop database link FSPRD;



>-----Original Message-----
>From: ext Yang Yanyan (JSC-OH230)[ARES]
>[mailto:oracledba-ezmlmshield-x76184310.[Email address protected]
>Sent: 31 January, 2008 19:41
>To: LazyDBA Discussion
>Subject: RE: Drop db link
>
>Thanks. But it is not public link.
>
>-----Original Message-----
>From: Israel Laureano Lazcano
>[mailto:oracledba-ezmlmshield-x13895359.[Email address protected]
>Sent: Thursday, January 31, 2008 11:24 AM
>To: LazyDBA Discussion
>Subject: Re: Drop db link
>
>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
>>
>>
>>
>>
>>
>>
>
>
>---------------------------------------------------------------------
>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