SQL & PL/SQL

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!

Dropping a database link in another schema

333422Feb 17 2004 — edited Feb 17 2004

Hi,

I have a schema named strmadmin which contains a database link named "hlrdb.site1". When I drop (and recreate) this link from the strmadmin schema is works fine. My problem is that I cant drop it when connected as sys.

SQL> select owner, db_link from dba_db_links;

OWNER
------------------------------
DB_LINK
--------------------------------------------------------------------------------------------------------------------------------
STRMADMIN
HLRDB.SITE1

1 row selected.

SQL> drop database link strmadmin.hlrdb.site1;
drop database link strmadmin.hlrdb.site1
*
ERROR at line 1:
ORA-02024: database link not found

Cheers,

Warren

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2004

Added on Feb 17 2004

3 comments

2,747 views