how to drop a private database link ?

From: Jean-Luc Martou <martou_at_sia.ucl.ac.be>
Date: Mon, 20 Jul 1998 16:20:30 +0200
Message-ID: <35B3522E.751C304B@sia.ucl.ac.be>

I'm sys or system.

I want to drop a private database link from an other user.

Is it possible ? If yes, how ?

Example : user 'scott' create a private dabase link 'data1' like that :

create database link data1 connect to user1 identified by user1 using 'data1.world' ;

I don't knwon the password of scott, but I want to drop his private link.

The command :

"drop database link scott.data1.world" is not correct.

Thanks

Jean-Luc Martou
Project Manager
Service d'informatique administrative (SIA) Universite catholique de Louvain

Place de l'Universite 1                    Tel : 32-(0)10-47.81.57
B-1348 Louvain-La-Neuve                    Fax : 32-(0)10-47.35.71

Belgium

Acknowledge-To: <Martou_at_sia.ucl.ac.be> Received on Mon Jul 20 1998 - 09:20:30 CDT