RE: dropping a database link

From: Henry Poras <Henry.Poras_at_ctp.com>
Date: Mon, 13 Aug 2001 08:28:10 -0700
Message-ID: <F001.00368C3A.20010813083525@fatcity.com>

Quoting from the Distributed Database Systems Manual (8.1.6) "You can drop a database link just as you can drop a table or view. If the link is private, then it must be in your schema."

So yes, a dba cannot drop database links owned by other users unless you use your power (for good) to switch to the other schema.

Henry

-----Original Message-----

[mailto:Shrinivas.Tatireddy_at_med.ge.com]
Sent: Saturday, August 11, 2001 12:01 AM To: Multiple recipients of list ORACLE-L

so a dba cannot drop databaselinks owned by other users.

am i correct?

-----Original Message-----

Sent: Friday, August 10, 2001 3:47 PM
To: Multiple recipients of list ORACLE-L

drop database link scott.mylink; will only work if the link name is scott.mylink, not if it is named mylink and owned by scott. If scott owns
the link (private link), scott must drop the link. ('.' is a valid character
in a database link name. Schema's cannot be specified).

Henry

-----Original Message-----

Sent: Friday, August 10, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L

srinvias,
Is the link a [public] or private link.
You must specify or the link will not be found. ROR mª¿ªm

>>> Shrinivas.Tatireddy_at_med.ge.com 08/10/01 11:00AM >>> hi lists

when i tried to drop a users database link from sys or system, system is denying and reporting database link not found.

i used

drop database link scott.mylink;

is there any way to do this. i dont have password for that user.

regards
srinvias
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tatireddy, Shrinivas (MED, Keane) INET: Shrinivas.Tatireddy_at_med.ge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ron Rogers
INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Henry Poras
INET: Henry.Poras_at_ctp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message