Re: ORACLE UPGRADE 10.2.0.2 ... INVALID MATERIALIZED VIEW
From: <blueprince10_at_gmail.com>
Date: Mon, 14 Apr 2008 01:12:05 -0700 (PDT)
Message-ID: <168f4a1c-2b8e-4eef-a646-089cdb6c7ecd@n14g2000pri.googlegroups.com>
Date: Mon, 14 Apr 2008 01:12:05 -0700 (PDT)
Message-ID: <168f4a1c-2b8e-4eef-a646-089cdb6c7ecd@n14g2000pri.googlegroups.com>
On Apr 13, 11:04 am, "aman.oracle.dba" <aman.oracle...._at_gmail.com>
wrote:
> 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
Can you select on the Materialized View and see if return any error? Received on Mon Apr 14 2008 - 03:12:05 CDT