Re: ORACLE UPGRADE 10.2.0.2 ... INVALID MATERIALIZED VIEW

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 18 Apr 2008 18:42:55 +0200
Message-ID: <4808cf84$0$14357$e4fe514c@news.xs4all.nl>

"DA Morgan" <damorgan_at_psoug.org> schreef in bericht news:1208536299.522086_at_bubbleator.drizzle.com...
> aman.oracle.dba 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
>
> Your statement is logically impossible.
>
> SQL> CREATE MATERIALIZED VIEW servers
> 2 TABLESPACE uwdata
> 3 NOCACHE
> 4 LOGGING
> 5 NOCOMPRESS
> 6 NOPARALLEL
> 7 BUILD IMMEDIATE
> 8 REFRESH FORCE ON DEMAND
> 9 WITH ROWID AS
> 10 SELECT * FROM servers;
> SELECT * FROM servers
> *
> ERROR at line 10:
> ORA-00955: name is already used by an existing object
>
> SQL>
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damorgan_at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

That's what I meant 3 days ago.

Shakespeare Received on Fri Apr 18 2008 - 11:42:55 CDT

Original text of this message