How does Oracle server manage dependencies among objects?
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.
How does Oracle server manage dependencies among objects?
Rating:
Oracle server automatically records dependencies among objects. To manage dependencies, all schema objects have a status (VALID or INVALID) that is recorded in the data dictionary. The status of a schema object can be viewed by querying the USER_OBJECTS data dictionary view. If an object has a valid status, it indicates that the object has been compiled and can be immediately used when referenced by another object or subprogram. On the other hand, if an object has an invalid status, it indicates that the object must be compiled before it can be used.
Rating:
Was this information helpful?
Other articles
- What are the different subprograms provided with the DBMS_JOB Oracle supplied package?
- What is the UTL_HTTP Oracle supplied package?
- What are the benefits of subprograms?
- What is a procedure?
- What is an INSTEAD OF trigger?
