Materialized view (Snapshot) creation

[Mrutyunjay Hanchinal]

Hi All,
I am trying to crate a Materialized view in Oracle 8i. This view is being created by joining 4 tables out of which 2 tables have very large number of records. When I try to create this snapshot, I do not get any error but the process never ends. What might be the problem?
Please Suggest.
Thanks,
Mrutyunjay.

[Mark Spritzler]

What are your join statements, are you sure there isn't a cartesian product being created. Have you tried getting an execution plan and look at the cost numbers.
A Materialized view takes a little longer to create than a table as it has a little bit more overhead to store with the "Table/View" like the query and links to the "Base" tables, which allows it to be refreshed.
Good Luck
Mark