PPT Slide
A view becomes invalid due
to the redefinition or deletion
of a table that underlies the
view. To fix this, the creator of
the view must either re-create
the underlying table and issue
the alter view command, or
modify the view with the create
or replace view statement.
The invalidation of a view as a result of
the removal of the underlying table
illustrates an example of object
dependency in the Oracle database.