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:[EMAIL PROTECTED]]
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
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
