What is local dependency?

What is local dependency?

Rating:

In case of local dependencies, the objects are on the same node in the database. The Oracle server automatically manages all local dependencies by using the database's internal "depends-on" table. When a referenced object is modified, the dependent objects are invalidated. The next time an invalidated object is called, the Oracle server automatically recompiles it. If the automatic recompilation of the object fails, it remains invalid and Oracle server returns a run-time error.

For example, if the structure of a table on which a view is based is modified, the view becomes invalid. When the DESCRIBE command is used to describe the view, an error message is returned stating that the object is invalid to describe. However, if the view is queried, the view is recompiled automatically and the result is displayed if the view gets recompiled successfully.

Rating: