creating snapshot

Consider the table myTable:

            first_name    varchar2(25),
            last_name    varchar2(25),
            regNum        number,
            status          varchar(20)   -> nullable  with default

Primary Key is first_name, last_name, status

While creating a snapshot on this table :

create snapshot mySnapshot refresh fast as select  

first_name,  

last_name,  

regNum,  

decode(status, 'new', null, status) as status

                                                                 from

I get the following message:
ORA-12016: materialized view does not include all primary key columns

But when i omitted out the decode part, it worked fine. Can snapshot be created with a decode on pk column (without using rowid clause)? Received on Thu Dec 27 2007 - 00:58:43 CST