DatabaseAdministrator wrote:you cant delete database links of other schema even if you are super user.
How to drop a database object for example, "MYDB.MYDBLINK" that is present in SCOTT schema.
When I try the following options connected as DBA it is giving error,in above case database consider '' SCOTT"."MYDB.MYDBLINK1 '' as a dblink name, so the error is expected.
DROP DATABASE LINK "SCOTT"."MYDB.MYDBLINK1";
ORA-2024: Database link not found.