MV Error:ORA-12014: table 'TEST_DATA' does not contain a primary key constraint

I am trying to create Materialized Views as follows:

Create MATERIALIZED VIEW TEST_DATA_MV
PCTFREE 0
PCTUSED 99
INITRANS 2
MAXTRANS 255
TABLESPACE T1
BUILD DEFERRED
REFRESH ON DEMAND
AS select * from SCHEMA_TEST.TEST_DATA_at_DBLINK;

ORA-12014: table 'TEST_DATA' does not contain a primary key constraint

The TEST_DATA table in the SCHEMA_TEST does NOT have a Primary Key and I do not want a primary key on TEST_DATA. What should I do to avoid error ORA-12014 ? I want to create this Materialized View WITHOUT the Primary Key, is there a way?

thanks for your help
Sajnish Received on Thu Nov 15 2001 - 15:10:45 CST