RE: Materialized View over 2 tables

Tue, 30 Oct 2001 00:52:16 -0800

Title: Materialized View over 2 tables

That’s not a problem. That is well-documented feature and you can check it with standard documents.

 

Fast Refreshes are meant only for simple MVs/Snapshots and not for complex ones. You are supposed

to do a complete refresh for complex ones.

 

HTH,

Rajesh

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daiminger, Helmut
Sent: Tuesday, October 30, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Materialized View over 2 tables

 

Hi!

Can I have a materialized view to be refreshed "fast", when it is created over 2 base tables? Fast refreshes work fine as long as the materialized view is based on 1 base table. But if the view is based on more base tables, it only seems to work with a complete refresh.

Does anybody have any experience with that problem?

This is 8.1.7 on Sun Solaris.

Thanks,
Helmut

Reply via email to