materialized view refresh
Date: 7 Jun 2003 02:50:06 -0700
Message-ID: <b381ffc7.0306070150.574b0036_at_posting.google.com>
Hi,
I need a solution on materialized view refresh.
when user A (Session A)is accessing materialized view MV1. The refresh
method we are using here is "REFRESH FORCE". Oracle job from the
session (Session B) issues a materialized view refresh. This refresh
removes data from MV1 and then refreshes (complete refresh) the MV1.
Please note that MV1 is on Oracle 9i. Master tables of MV1 are on
Oracle 8i. The query is a complex query.
If I put "REFRESH FAST" with in the create script I get the following
error
ORA-12015: cannot create a fast refresh materialized view from a
complex query
I need a solution that does mv1 refresh in a transaction. That is, when "Session B" is refreshing mv1, "Session A" should still be accessing old data.
Regards,
Sudhakar
Received on Sat Jun 07 2003 - 11:50:06 CEST