Revalidating Invalidated Views

(Bruno Vroman) Usually, when a view becomes invalid due to DDL work on the underlying table, its first usage (SELECT … FROM myview …) revalidates it, or it can be revalidated via “ALTER VIEW myview COMPILE;”. But sometimes a view remains invalid, such as when there is a bug. In a case like this,

Read More - Register for Free Membership