Re: ORACLE UPGRADE 10.2.0.2 ... INVALID MATERIALIZED VIEW

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