Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Materialized Views Question

Re: Materialized Views Question

From: Mark Townsend <markbtownsend_at_home.com>
Date: Sat, 06 Jan 2001 05:43:19 GMT
Message-ID: <B67BF08E.1087%markbtownsend@home.com>

I'm not sure if I have understood your question, but if you do regulary drop partitions om your base table you may want to look at partitioning your MV on the same partition key. I don't have the docs with me, but I think in 8.1.6 at least a dropped partition on the base table will only require a very simple fast refresh on the corresponding partition in the MV Received on Fri Jan 05 2001 - 23:43:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US