创建物化视图
Create materialized view MV_TEST_COMMIT
Build immediate
Refresh fast
On commit
With rowid
as
Select m1.id,m1.name,m2.ADRESS,m1.rowid m1rowid,m2.rowid m2rowid
from test_m1 m1,test_m2 m2
where m1.id = m2.id;
create materialized view mv_name refresh force on commit as select * from table_name
