Prev: oracle and database ebooks
Next: Query with NULL
From: z1hou1 on 28 Dec 2009 21:54
Hi,
I have a situation where I have a materialized view/log to refresh on
commit on a fact table that is subject to archive considerations. The
fact table is partitioned by date range.

Now, the materialized view has very few rows and therefore not
partitioned.

My question is, if older partitions in the fact table are dropped
because of an archiving exercise, what will be the state of the
materialized view that was based on a view log set to refresh on
commit.

Thanking you and regards,
z1hou1
From: Ed Prochak on 29 Dec 2009 11:01
On Dec 28, 9:54 pm, z1hou1 <z1h...(a)gmail.com> wrote:
> Hi,
> I have a situation where I have a materialized view/log to refresh on
> commit on a fact table that is subject to archive considerations. The
> fact table is partitioned by date range.
>
> Now, the materialized view has very few rows and therefore not
> partitioned.
>
> My question is, if older partitions in the fact table are dropped
> because of an archiving exercise, what will be the state of the
> materialized view that was based on a view log set to refresh on
> commit.
>
> Thanking you and regards,
> z1hou1

To be honest, I do not know. Why don't you try it and find out?
You do have a test instance to run this in right????
ed
From: joel garry on 29 Dec 2009 11:46
On Dec 28, 6:54 pm, z1hou1 <z1h...(a)gmail.com> wrote:
> Hi,
> I have a situation where I have a materialized view/log to refresh on
> commit on a fact table that is subject to archive considerations. The
> fact table is partitioned by date range.
>
> Now, the materialized view has very few rows and therefore not
> partitioned.
>
> My question is, if older partitions in the fact table are dropped
> because of an archiving exercise, what will be the state of the
> materialized view that was based on a view log set to refresh on
> commit.
>
> Thanking you and regards,
> z1hou1

This would seem to say yes, if you use the correct definitions, and
shows how to tell:
http://www.databasejournal.com/features/oracle/article.php/3633971/Oracle-10g-Materialized-View-Enhancements-Part-2.htm

jg
--
@home.com is bogus.
If at first you don't succeed, stay away from the rocks.
http://www.signonsandiego.com/photos/galleries/2009/dec/28/top-photos-week-dec-27-2009/3865/
 | 
Pages: 1
Prev: oracle and database ebooks
Next: Query with NULL