ORA-02024: Database Link Not Found [ID 1058949.1]

ORA-02024: Database Link Not Found [ID 1058949.1]
	Modified 24-JUN-2010Type PROBLEMStatus PUBLISHED

In this Document
Symptoms
Cause
Solution
References

Applies to:

Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.1.0.7 - Release: 8.1.7 to 11.1
Information in this document applies to any platform.

Symptoms

After performing an import from 9i to 11g, encountered the following issue:

SQL> DROP DATABASE LINK SUPPORT.PRODREP ;
drop DATABASE LINK SUPPORT.PRODREP
*
ERROR at line 1:
ORA-02024: database link not found

Cause

Incorrect SQL syntax for dropping a public database link

In this case, the link was owned by user 'PUBLIC' not the user 'SUPPORT'

SQL> SELECT * FROM all_db_links;

OWNER DB_LINK USERNAME
----------- ------------- -----------------
PUBLIC PRODREP SUPPORT

Solution

Correct the syntax to include the word 'public'
DROP PUBLIC DATABASE LINK <name of link>

------------------------------------------------------------------------------

Blog： http://blog.youkuaiyun.com/tianlesoftware

网上资源： http://tianlesoftware.download.youkuaiyun.com

相关视频：http://blog.youkuaiyun.com/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群：62697716(满); DBA2 群：62697977(满)

DBA3 群：62697850 DBA 超级群：63306533;

聊天 群：40132017

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请