Dependencies Among Other Remote Schema Objects (255)

最新推荐文章于 2020-04-27 19:31:02 发布

转载最新推荐文章于 2020-04-27 19:31:02 发布 · 80 阅读

本文探讨了Oracle数据库中远程模式对象的依赖性管理问题，特别是对于本地视图和过程引用远程表的情况。当远程表定义发生变化时，Oracle并不会自动使这些本地对象失效，即使它们在使用时可能会返回错误。文章指出了在这种情况下手动调整视图和过程定义的必要性。

Oracle does not manage dependencies among remote schema objects other than
local-procedure-to-remote-procedure dependencies.

For example, assume that a local view is created and defined by a query that
references a remote table. Also assume that a local procedure includes a SQL statement
that references the same remote table. Later, the definition of the table is altered.

As a result, the local view and procedure are never invalidated, even if the view or
procedure is used after the table is altered, and even if the view or procedure now
returns errors when used. In this case, the view or procedure must be altered manually
so that errors are not returned. In such cases, lack of dependency management is
preferable to unnecessary recompilations of dependent objects.

其他远程方案对象的依赖性
1.
在远程表的定义被修改后使用本地视图或过程，甚至在使用过程中返回了错误，本地视图及过程都不会被置为无效
状态
2. 这种情况下，必须手工修改视图或过程的定义才能避免错误发生。
这样处理依赖性问题能够避免对依赖对象进行不必要的编译

[@more@]

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

转载于:http://blog.itpub.net/10599713/viewspace-985294/