Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshot on a Snapshot
Some problems with nested materialized views:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=130ba93a.0211191124.7c9dadde%40posting.google.com http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=130ba93a.0210251116.72e8bfaf%40posting.google.com
Also, you might want to take a look at 9i CDC (change data capture) see if it makes life easier for you.
You might want to take a look at CDC (change data capture)
aennen_at_amdocs.com (Alan) wrote in message news:<bdcc590d.0212101011.3acce77e_at_posting.google.com>...
> Is this possible and if so are there any issue of risks that one
> should be aware of in doing something like this.
>
> What we are trying to accomplish is to have a seperate table (fondly
> called a delta table) with only the changes that have occured over a
> period of time but still keeping the oringinal snap shot full and
> intact for performance reasons.
Received on Thu Dec 12 2002 - 11:57:23 CST