cant drop the database links
444833Jan 7 2006 — edited Jan 10 2006i 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 ??