I have created the following MV log and MV(empno was the only primary key in empbak).
create materialized view log on empbak with primary key including new values;
create materialized view mv_empbak build immediate refresh fast on commit as select empno,ename from empbak;
Note that when create MV log "ename" was not included in the log, but it was appeared in the MV.
I then updated ename of empbak and found all modification with ename can still be updated to mv_empbak;
I have 2 questions about the above test:
1. Since ename is not included in the MV log, why it could still successfully be updated in the MV ?
2. As long as the primary key or rowid was included in the MV log, then it does not matter whether other columns was included in the MV log ?
Thanks in advance.