Materialized Views in Oracle (Part - 2 Practical Implementation with Examples)

This video explains the syntax of creating a materialized view in oracle database, and also a brief demo of creating materialized view, refreshing the MV and dropping the MV is shown in this free video tutorial.

[shashank]

nice explanation... but m confused about what's d use of 'enable query rewrite'?? pls explain in brief

[sameerahmad]

Hi Kishan, which Oracle Edition you are plz let me know...

[ramchinthakayala]

do we need to create log table for complete and force refresh methods too ?

[vijayadiwakar]

Hai kishan can u do videos mv fast, complte and force refresh also plz

[vijayadiwakar]

Can u tell me how to schedule a job using materialised view

[vishwaskhare]

Can I use materialized view, triggers and cursor in a procedure

[Jsinghchandel]

Sir, I have a huge SQL query of over 2.5k lines(lots of had case than condition) and i want to create materialized view for that. Requirement is that i need to use the whole output record set to the reporting which is a different tool. Due to large data set my SQL query runs around 1 hr to generate result. Would fast refresh be recommended for this. Can you pls guide.

[manojncse]

good video... can we schedule a mv to run every 2 hours without creating a job ? if so, how to do it ?

[mahendramungamuru]

I have a materialized view...how to check this materialized view is getting data from which tables.... please comment anyone...this will be helpful for me.

[sankarmeganth]

Audio and video are not in sync .. bit confused to follow

[namanpreetsingh]

Nice explanations but background sound is disturbing. Dear work on clarity