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

Report message to a moderator

- 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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 07 09:50:27 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.