ITPub博客

首页 > IT基础架构 > 网络安全 > Dependencies Among Other Remote Schema Objects (255)

Dependencies Among Other Remote Schema Objects (255)

原创 网络安全 作者:tsinglee 时间:2007-11-27 09:32:52 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892247