Shulou(Shulou.com)05/31 Report--

This article mainly explains "what to do when deleting database link Times from Oracle". Interested friends might as well take a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what to do if you delete the database link Times from Oracle"!

Oracle 11.2.0.3

Error found when deleting database link: ORA-02024: database link not found

1. Confirm whether the database link is public database link. If so, it does not have to be the owner of the dblink.

Sufficient permissions can be deleted.

two。 If it is private database link, then you need owner to delete it, otherwise an error will be reported.

3. The global_name was changed before and after creation. The original global_name=true was changed to false after the creation of dblink.

In this case, the dblink cannot be deleted normally even if it is changed back.

At this point, I believe you have a deeper understanding of "what to do by deleting the database link Times in Oracle". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.