Is there any site /explanation for Materialized Views(all types ) with proper dataset and example.Data is equally important to check the changes practically.The documents provided by Oracle is lengthy and is difficult at times for a start .Would appreciate if someone shares a good documentation .
Check out these -
(contains Table creation, Insert statements and MView scripts)
Practically do the workouts and reading the theory alone will not help.
Just saw what Jeneesh replied and absolutely agree to it. +'No substitute/shortcut to learning and success'+ .
Keep patience and read the Oracle documentation thoroughly. It will contain every possible clause possible with MViews.
No other material will provide such an in-depth knowledge as the official documentation.