oracle concepts

最新推荐文章于 2025-12-01 18:34:47 发布

转载最新推荐文章于 2025-12-01 18:34:47 发布 · 133 阅读

文章标签：

#数据库

本文探讨了Oracle数据库中对象间的依赖性，特别是依赖对象和引用对象之间的关系。当某些对象发生变化时，可能会导致依赖这些对象的其他对象变为无效状态，进而触发重编译。文章还讨论了Oracle如何通过依赖关系表管理和解决这种依赖性。

刚看了一章oracle concepts的一章，对象间的依赖性。主要是依赖对象和引用对象的一些关系，某些引用对象变化后，直接或间接影响依赖其存在的对象的invlid，产生某些重编译。本地的依赖对象管理通过依赖关系表进行；远程的主要管理过程间的依赖关系，通过时间戳和特征标识。

关键点：

Oracle attempts to recompile an invalid object dynamically only if it has not been replaced since it was detected as invalid. This optimization eliminates unnecessary recompilations

Remember that whenever you create a table, index, and view, and then drop the index, all objects dependent on that table are invalidated, including views, packages, package bodies, functions, and procedures. This protects updatable join views

Because of how Oracle resolves references, it is possible for an object to depend on the nonexistence of other objects. This situation occurs when the dependent object uses a reference that would be interpreted differently were another object present

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25803188/viewspace-695212/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25803188/viewspace-695212/