Saved Bookmarks
| 1. |
How Does Oracle Manage Dependencies Across Remote Databases On Distributed Networks? |
|
Answer» Oracle does not manage dependencies across remote schema objects on DISTRIBUTED NETWORKS other than local-procedure-to- remote procedure dependencies. It only manages dependencies among stored procedures (procedures, functions, and PACKAGES) using time-stamped checking or signature checking. If there is a local VIEW BASED on a remote table, and the remote table definition is altered, the local view is not invalidated. Oracle does not manage dependencies across remote schema objects on distributed networks other than local-procedure-to- remote procedure dependencies. It only manages dependencies among stored procedures (procedures, functions, and packages) using time-stamped checking or signature checking. If there is a local view based on a remote table, and the remote table definition is altered, the local view is not invalidated. |
|