creating snapshot

From: <>
Date: Wed, 26 Dec 2007 22:58:43 -0800 (PST)
Message-ID: <>

Consider the table myTable:

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

Primary Key is first_name, last_name, status

While creating a snapshot on this table :

create snapshot mySnapshot refresh fast as select  




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


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

Original text of this message