What is dependency failure?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is dependency failure?
Rating:
Some objects reference other objects as part of their definition. For example, a procedure can contain a SELECT statement that selects columns from a table. If a procedure references a table, the procedure is said to be dependent on the table. The procedure is called a dependent object, whereas the table is called a referenced object.
If the definition of a referenced object is altered, dependent objects become invalid. This is known as dependency failure. The dependent objects need implicit or explicit recompilation before they can become valid.
Rating:
Was this information helpful?
Other articles
- What is system privilege?
- What is the USER_OBJECTS data dictionary view?
- What is the REMOTE_DEPENDENCIES_MODE parameter?
- What is a row trigger?
- What are the restrictions on a user-defined function that is called from a SQL expression?