ORACLE UPGRADE 10.2.0.2 ... INVALID MATERIALIZED VIEW
From: aman.oracle.dba <aman.oracle.dba_at_gmail.com>
Date: Sat, 12 Apr 2008 20:04:28 -0700 (PDT)
Message-ID: <748520ea-09a6-4a06-8457-2e87207eca74@e67g2000hsa.googlegroups.com>
VALID TABLE
INVALID MATERIALIZED VIEW Can someone kindly help in it.
Date: Sat, 12 Apr 2008 20:04:28 -0700 (PDT)
Message-ID: <748520ea-09a6-4a06-8457-2e87207eca74@e67g2000hsa.googlegroups.com>
I have upgrade oracle from 9.2.0.2 to 10.2.0.2 on SunOS.
SQL> alter MATERIALIZED VIEW MVIEWUSER.PCATTYPE compile;
Materialized view altered.
SQL> select status,object_type from dba_objects where owner='MVIEWUSER' AND object_name='PCATTYPE';
STATUS OBJECT_TYPE
------- -------------------
VALID TABLE
INVALID MATERIALIZED VIEW Can someone kindly help in it.
Thanks Received on Sat Apr 12 2008 - 22:04:28 CDT