Dependencies and Views (180)
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 會自動地處理檢視的依賴性
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-981771/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- DML ViewsView
- Injection of autowired dependencies failed;AI
- Fine Grained DependenciesAI
- dba_dependencies scripts
- Management of Remote Dependencies (252)REM
- Dependencies of Applications (256)APP
- 8.1.1 V$ ViewsView
- 8.1.2 GV$ ViewsView
- Parallel query & viewsParallelView
- External Views (33)View
- Overview of Views (174)View
- 讀懂 gradle dependenciesGradle
- Resolution of Schema Object Dependencies (241)Object
- barbajs-ViewsJSView
- Some Dictionary Views For ASMViewASM
- Views and Base Tables (243)View
- How Views are Stored (175)View
- How Views Are Used (176)View
- Mechanics of Views (177)View
- Object Views (182)ObjectView
- dependencies 和 devDependencies 的異同dev
- Dependencies for Graphs 閱讀筆記筆記
- Oracle's V$ Views(轉)OracleView
- About Static Data Dictionary ViewsView
- Views with the Prefix USER (267)View
- Views with the Prefix ALL (268)View
- Views with the Prefix DBA (269)View
- Globalization Support Parameters in Views (178)View
- Updatable Join Views (181)View
- Overview of Materialized Views (184)ViewZed
- Refresh Materialized Views (189)ZedView
- Dependencies Among Local and Remote Database Procedures (252)REMDatabase
- Dependencies Among Other Remote Schema Objects (255)REMObject
- [譯]Flutter for Android Developers - ViewsFlutterAndroidDeveloperView
- Whats the difference between the v$sql* viewsSQLView
- Oracle 10G V$ViewsOracle 10gView
- [DW]An article about Materialized Views(zz)ZedView
- Extents in Materialized Views and Their Logs (18)ZedView