Hi, you have to create materialized view log for all the referenced tables that you use in the mview. Also to fast refresh a materialized join view, you must create a materialized view log for each of the tables referenced by the materialized view.
Hi Sridhar , I have one question . suppose I have created Materialized view by joining 3 tables. Now my question is on which table we will create materialized view log.
Very nice Explanation for new learners, Keep it up SRIDHAR.
Good.. Lage Raho....
Hi Shridhar ,
can you please share the video to create materialized view on prebuilt table.
Thank you.
Hi, you have to create materialized view log for all the referenced tables that you use in the mview.
Also to fast refresh a materialized join view, you must create a materialized view log for each of the tables referenced by the materialized view.
Nice lecture sir
nice explanation ,which refresh is faster among 3 ?
Nice explanation sir,What the use of enable query rewrite pls explain with example??
in scheduled refresh the value from Govind to Guy is not reflected in MV only rowids got changed. Why?
Ragavaaaaaaaa Super yaaaa
Patharathingaaa ragavaaaa . the way u presented is very good.
Bhaaaaaaiiiiii
Hi Sridhar , I have one question .
suppose I have created Materialized view by joining 3 tables.
Now my question is on which table we will create materialized view log.
I think we need to create the view log in the schema where 3 tables reside not table specific
not clear sridhar
can u share word document for this.so that it will very helpful for us
can we delete meterialized view directly
why this video is age restricted?
Sir pls send me any kind of material this topic pls send me help us pls sir
Dear sir can u plz send me this document