Re: ORACLE UPGRADE 10.2.0.2 ... INVALID MATERIALIZED VIEW
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