materialized view refresh

[sudhakard]

Hi,
I need a solution on materialized view refresh. The refresh method we are using here is "REFRESH FORCE".
when user A (Session A)is accessing materialized view MV1. 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.

Thanks&Regards,
Sudhakar

 

[Scunningham99]

Neither rowids and nor primary key constraints are supported for complex queries.

Reissue the command with the REFRESH FORCE or REFRESH COMPLETE option or create a simple snapshot.

Sy UK