Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

A column is needed in MV,What if i don't include this column in MV log

Status
Not open for further replies.

signalsys

Technical User
Sep 5, 2005
44
CN



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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top