Skip to Main Content

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!

cant drop the database links

444833Jan 7 2006 — edited Jan 10 2006
i would like to know how to remove db links which dont have a db_domain.

drop database link <linkname>;

but gives me error. database link does not exist.

14:50:29 SQL> drop public database link vir1_now;
drop public database link vir1_now
*
ERROR at line 1:
ORA-02024: database link not found

this occurs in oracle 8.1.7

OWNER DB_LINK USERNAME HOST CREATED
--------------- --------------- ---------- ------------- ---------
PUBLIC VIR1_NOW TSTUSR eisa 25-MAY-04

all my new db-links are getting appended with a domain .WORLD or .NET etc. (i guess this is because of the db_domain set)

but the old db-links dont have a domain.

now how am i supposed to remove those old db-links ??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2006
Added on Jan 7 2006
4 comments
757 views