Hi All

Is it Possible to create a materialized view if the underlying table has no primary key?

I tried creating a materialized view without specifying the refresh mode and I get an

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

Please Assist