Dependencies and Views (180)

tsinglee發表於2007-11-11

Because a view is defined by a query that references other objects (tables, materialized
views, or other views), a view depends on the referenced objects. Oracle automatically
handles the dependencies for views. For example, if you drop a base table of a view
and then create it again, Oracle determines whether the new base table is acceptable to
the existing definition of the view.

檢視的依賴性
1. 由於檢視的定義是一個引用了其他物件的查詢,因此檢視依賴於其所引用的物件
2. Oracle 會自動地處理檢視的依賴性

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-981771/,如需轉載,請註明出處,否則將追究法律責任。

相關文章