CREATE TABLE mview_table AS
  SELECT object_name, object_id, object_type
    FROM all_objects
   WHERE ROWNUM <= 5;

CREATE MATERIALIZED VIEW mview_complete AS
  SELECT *
    FROM mview_table;

SELECT object_name, object_id, rowid
  FROM mview_complete;

EXECUTE DBMS_MVIEW.REFRESH('mview_complete'); 

ALTER TABLE mview_table
 ADD CONSTRAINT mview_table_pk
 PRIMARY KEY (object_id);