As we know, the private db_links can be dropped only by the owner of the database_link.  But you don’t have the password that db_link owner, then there is a workaround for that. SQL>select * from dba_db_links where OWNER=’SCOTT’; OWNER DB_LINK USERNAME HOST CREATED —————————— ——————– —————————— ——————– ——— SCOTT LINK1 SCOTT testdb 04-NOV-11 SQL>drop database … Continue reading How to drop a private database link From sys