标题: ORA-02024: Database Link Not Found [打印本页] 作者: 刘泽宇 时间: 2024-3-10 10:49 标题: ORA-02024: Database Link Not Found 现象：
Encountering the following issue:
SQL> DROP DATABASE LINK <SCHEMA_NAME>.<DBLINK_NAME> ;
drop DATABASE LINK <SCHEMA_NAME>.<DBLINK_NAME>
*
ERROR at line 1:
ORA-02024: database link not found
原因：
Incorrect SQL syntax for dropping a public (or private) database link
In this case, the link was owned by user 'PUBLIC' not the user '<SCHEMA_NAME>'
SQL> SELECT * FROM all_db_links;
OWNER DB_LINK USERNAME
----------- ------------- -----------------
PUBLIC <DBLINK_NAME> <SCHEMA_NAME>
注意：
The same error can be encountered if the user is not the owner of a private database link
To drop a private database link, the database link must be in your own schema. It is impossible to drop a database link in another user's schema, not even with DBA privileges. Qualifying the link name with the schema name does not work. The reason is that periods are permitted in names of database links.
处理方法：
For a public database link, correct the syntax to include the word 'PUBLIC':