Home » Server Options » Replication » Materialized View Refresh
Materialized View Refresh [message #199468] Tue, 24 October 2006 10:17 Go to next message
aafreens
Messages: 1
Registered: October 2006
Junior Member
I have a materialized view which was created using a view for e.g.

CREATE MATERIALIZED VIEW MV_TEST_DATA
BUILD IMMEDIATE
REFRESH FORCE
ON DEMAND
ENABLE QUERY REWRITE
AS SELECT * from VW_TEST_DATA_LOADER

Where VW_TEST_DATA_LOADER is View whcih has multiple joins.

How can i perform a fast refresh on this MV.

Thanks
Re: Materialized View Refresh [message #201488 is a reply to message #199468] Sat, 04 November 2006 15:30 Go to previous message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Change force to fast.

If You have gone through ALL the (documented) steps, it will fast refresh.

Tx. have You created a MV log?
Are You selecting rowid's in the view?
Are You doing any group by etc. in the view?
Why are You using the view at all?

use dbms_mview.explain_mview !!!!

Br
Kim
Previous Topic: logminer error
Next Topic: Cloning and Replication
Goto Forum:
  


Current Time: Fri Mar 29 01:22:56 CDT 2024