Hi,
I am trying to create a MV, from a table int_group_master which does not have any primary key, and getting the ora-12014 error.

SQL> CREATE MATERIALIZED VIEW MV_INT_GROUP_MASTER
2 PCTFREE 0 TABLESPACE data_local
3 BUILD IMMEDIATE
4 REFRESH COMPLETE ON DEMAND
5 AS
6 SELECT gm_id,
7 gm_domestic_cd,
8 gm_desc
9 FROM INT_GROUP_MASTER
10 WHERE enterprisekey = 0;
FROM INT_GROUP_MASTER
*
ERROR at line 9:
ORA-12014: table 'INT_GROUP_MASTER' does not contain a primary key constraint

How to get out of this, without creating a primary key on the base table? There are no dblinks being used and I tried fully qualifying the tablename(with the owner name), but the results are same.

Thanks
Manjunath