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.
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
0
