Hello,

Can anyone help on this problem? I am trying to drop a database link and
received the error message.

SQL> sho user
USER is "SYSADM"
SQL> select * from user_db_links;

DB_LINK USERNAME PASSWORD
HOST CREATED
-------------------- ------------------------------
------------------------------ -------------------- ---------
FSPRD SYSADM BLUESKY
FSPRD 12-DEC-05


SQL> drop database link FSPRD;
drop database link FSPRD
*
ERROR at line 1:
ORA-02024: database link not found

SQL> select * from global_name;

GLOBAL_NAME
------------------------------------------------------------------------
------------------------------------------------

HRPRD.WORLD

SQL> sho parameter global

NAME TYPE VALUE
------------------------------------ -----------
------------------------------
global_context_pool_size string
global_names boolean FALSE


Thanks

Yanyan

Oracle LazyDBA home page