Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Drop database link in another schema as DBA is not working

dba-indiaMar 20 2013 — edited Mar 20 2013

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,

DROP DATABASE LINK "SCOTT"."MYDB.MYDBLINK1";
ORA-2024: Database link not found.

DROP DATABASE LINK SCOTT.MYDB.MYDBLINK1;
ORA-2024: Database link not found.

DROP DATABASE LINK 'SCOTT'.'MYDB.MYDBLINK1';
ORA-2024: Database link not found.

DROP DATABASE LINK SCOTT.MYDB.MYDBLINK1;
ORA-2024: Database link not found.

Always I have to connect as SCOTT to drop the database link MYDB.MYDBLINK1 that is present in SCOTT's schema.

Please provide the way to drop the database link in another schema without connecting as that schema owner, while I can connect as a DBA (SYSTEM or SYS).

This post has been answered by TSharma-0racle on Mar 20 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2013

Added on Mar 20 2013

#general-database-discussions

5 comments

11,116 views