Hi,
this question have i also placed here and that is to say 20 questions before your and the answer is also there.
What happends:
You must have the rights to create a snapsshot.

Now a question to you or provocation:

I've got the following situation: a star schema with
one fact table and a couple of dimension tables.

I'm filling in new data into the fact table and deleting
old data periodically from the fact table (that is, I'm
implementing some kind of ring buffer).

Also, there are MVs defined on the star schema.
The problem is to retain aggregated data in the MVs,
even after the corresponding detail data in the fact table
has been deleted.

The MV should aquire new data arriving in the fact table,
but should NOT "synchronize" with the deleted data.

Can this be achieved?

Any help would be greatly appreciated.

Greets,
Thomas Schmidt

[Edited by tomate on 06-01-2001 at 01:36 AM]