| Materialized View Refresh [message #199468] |
Tue, 24 October 2006 10:17  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
