Oracle Database Discussions

Hi all,

I'm trying to create simple Mview on one big table on specific column as below eg:

this is my table :
CREATE TABLE XXX
(
A VARCHAR2(10 BYTE),
B VARCHAR2(10 BYTE),
C NUMBER,
D DATE,
E varchar2(10),
F varchar2(10),
G varchar2(5)
);

and I want to create mView on a few column as normal select statment, the purpose of this mView is to bush query performance as we need only information from A, B, D:

CREATE MATERIALIZED VIEW TEST_MV
REFRESH fast ON commit
ENABLE QUERY REWRITE AS
Select
a,b,d
from xxx;

when i create above mView, i got the error message :
"ORA-12014: table 'XXX' does not contain a primary key constraint"

what is the solution? pls help!!!

iKhmer