| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dropping a database link
I remember raising a TAR on this issue about 5 years ago and the upshot was that it was a known oddity and I should raise an enhancement request.
I am sure I did raise such a request but never heard anything more about it.
Regards
John
-----Original Message-----
From: Henry Poras [mailto:Henry.Poras_at_ctp.com]
Sent: 13 August 01 17:35
To: Multiple recipients of list ORACLE-L
Subject: RE: dropping a database link
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 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: 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).
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).
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).
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).
 |
 |