PREREQUISITES:
To drop a private database link, the database link must be in your
own schema. To drop a PUBLIC database link, you must have DROP
PUBLIC DATABASE LINK system privilege.

If you are using Trusted Oracle in DBMS MAC mode, your DBMS label
must match the database link's creation label or you must satisfy
one of these criteria:

* If the database link's creation label is higher than your DBMS
label, you must have READUP and WRITEUP system privileges.
* If the database link's creation label is lower than your DBMS
label, you must have WRITEDOWN system privilege.
* If the database link's creation label and your DBMS label are
noncomparable, you must have READUP, WRITEUP, and WRITEDOWN
system privileges.

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