ora-12014 while creating a materialized view
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
6 SELECT gm_id,
9 FROM INT_GROUP_MASTER
10 WHERE enterprisekey = 0;
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.