Re: ORACLE UPGRADE 10.2.0.2 ... INVALID MATERIALIZED VIEW

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 15 Apr 2008 10:02:41 +0200
Message-ID: <48046128$0$14343$e4fe514c@news.xs4all.nl>

<blueprince10_at_gmail.com> schreef in bericht news:168f4a1c-2b8e-4eef-a646-089cdb6c7ecd_at_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?

I wonder how you select from an MV when the table has the same name and know where the data came from.....

Shakespeare
(What's in a name?) Received on Tue Apr 15 2008 - 03:02:41 CDT

Original text of this message