Tracking dependencies and completing necessary recompilations are performed
automatically by Oracle. Local dependency management occurs when Oracle
manages dependencies among the objects in a single database. For example, a
statement in a procedure can reference a table in the same database.

Remote dependency management occurs when Oracle manages dependencies in
distributed environments across a network. For example, an Oracle Forms trigger can
depend on a schema object in the database. In a distributed database, a local view’s
defining query can reference a remote table.

本地与远程依赖性管理
1. 本地依赖性管理是指 Oracle 管理一个单一数据库内各个对象间的依赖关系
2. 远程依赖性管理是指 Oracle 管理一个分布式环境内的各种依赖关系
以上都是由Oracle自动管理