Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to compile invalid MATERIALIZED VIEW ?

775823Feb 8 2011 — edited Feb 8 2011

How to compile invalid MATERIALIZED VIEW ?

SQL> select owner,object_type,COUNT(*) from dba_objects where status='INVALID' group by owner, object_type;

OWNER OBJECT_TYPE COUNT(*)
----- ------------------- ----------
APPS MATERIALIZED VIEW 45

DB is Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2011

Added on Feb 8 2011

#general-database-discussions

9 comments

45,257 views