MV creation error

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Thu, 10 Feb 2005 13:21:24 -0500
Message-ID: <f09dd6280502101021549c4763@mail.gmail.com>

Could someone please let me know why this is happening and how to overcome this issue?  

SQL> show user
USER is "SAMI"
SQL> SQL> desc t2

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                              VARCHAR2(30)
 OBJECT_NAME                                        VARCHAR2(128)
 OBJECT_ID                                 NOT NULL NUMBER
 DATA_OBJECT_ID                                     NUMBER
 OBJECT_TYPE                                        VARCHAR2(18)
 CREATED                                            DATE

SQL> select CONSTRAINT_NAME,CONSTRAINT_TYPE from dba_constraints where table_name='T2' and owner='SAMI';  

CONSTRAINT_NAME                C


------------------------------ -

SYS_C0011178                   P
 

SQL> drop materialized view log on t2;  

Materialized view log dropped.  

SQL> create materialized view log on t2;  

Materialized view log created.  

SQL> create materialized view mv2 refresh fast with primary key as select object_type,count(*) from t2 group by object_type; create materialized view mv2 refresh fast with primary key as select object_type,count(*) from t2 group by object_type

                                                                      
                        *

ERROR at line 1:
ORA-12032: cannot use rowid column from snapshot log on "SAMI"."T2"    

SQL> create materialized view mv2 refresh fast with rowid as select object_type,count(*) from t2 group by object_type; create materialized view mv2 refresh fast with rowid as select object_type,count(*) from t2 group by object_type

                                                                      
                  *

ERROR at line 1:
ORA-12032: cannot use rowid column from snapshot log on "SAMI"."T2"  

SQL>
--

Sami Seerangan
Oracle DBA
--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 10 2005 - 13:24:09 CST