Dependencies Among Other Remote Schema Objects (255)
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. 這種情況下,必須手工修改檢視或過程的定義才能避免錯誤發生。
這樣處理依賴性問題能夠避免對依賴物件進行不必要的編譯
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-985294/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Dependencies Among Local and Remote Database Procedures (252)REMDatabase
- Oracle 19c Concepts(04):Partitions, Views, and Other Schema ObjectsOracleViewObject
- Management of Remote Dependencies (252)REM
- Resolution of Schema Object Dependencies (241)Object
- Introduction to Schema Objects (153)Object
- rdo(remote data objects) repo openstack icehouseREMObject
- Get detailed table(many other objects) structure with dbms_metadataAIObjectStruct
- Recompiling Invalid Schema ObjectsObject
- 1219 ORA-15021 remote_dependencies_modeREM
- How to Clean Up Duplicate Objects Owned by SYS and SYSTEM Schema_1030426.6Object
- the differents among SQL Oracle mysqlOracleMySql
- pymysql KeyError:255MySqlError
- Injection of autowired dependencies failed;AI
- Fine Grained DependenciesAI
- dba_dependencies scripts
- Dependencies of Applications (256)APP
- Dependencies and Views (180)View
- Runloop + runtime + otherOOP
- 域控安全-EventID 4662&Powershell將Schema下Objects的schemaIDGUID屬性離線儲存ObjectAIGUI
- 讀懂 gradle dependenciesGradle
- PHP函式庫(other)PHP函式
- Other SGA Initialization Parameters (96)
- Android Weekly Notes Issue #255Android
- 【檢視】oracle 資料字典檢視之 DBA_OBJECTS / ALL_OBJECTS / USER_OBJECTS(OBJ)OracleObject
- 前端如何設定背景顏色的透明度 css中的 rgba() 函式詳解 :background-color: rgba(255,255,255,0)前端CSS函式
- dependencies 和 devDependencies 的異同dev
- Dependencies for Graphs 閱讀筆記筆記
- Oracle dba_objects和all_objects 最大的區別OracleObject
- 淺談Associated ObjectsObject
- Destroying Window ObjectsObject
- create objects inmemory optionsObject
- Naming Database ObjectsDatabaseObject
- read by other session等待事件Session事件
- Python class中的otherPython
- read by other session 測試Session
- 等待事件:read by other session事件Session
- mount other server cdrom&directoryServer
- 【等待事件】read by other session事件Session