SQL> select * from ii;
N V
---------- --------
1 a
2 b
3 c
SQL> alter table ii add constraint ii_p primary key(n);
Table altered.
SQL> create materialized view v_ii refresh force on commit as select * from ii;
Materialized view created.
SQL>
N V
---------- --------
1 a
2 b
3 c
SQL> alter table ii add constraint ii_p primary key(n);
Table altered.
SQL> create materialized view v_ii refresh force on commit as select * from ii;
Materialized view created.
SQL>