Dependencies Among Other Remote Schema Objects (255)

tsinglee發表於2007-11-27

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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章