Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Materialized Views Question
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
![]() |
![]() |