Snapshot on a Snapshot

[Pete Sharman]

In article <bdcc590d.0212101011.3acce77e@posting.google.com >, [email]aennen@amdocs.com[/email]
says...

>
>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.

It certainly is in 9i, but unfortunately you didn't mention which version you're
on. Can't remember if it was there in 8i, but I don't think so.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements;

[Jusung Yang]

Some problems with nested materialized views:

[url]http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=130ba93a.0211191124.7c9dadde%40posting.goog le.com[/url]
[url]http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=130ba93a.0210251116.72e8bfaf%40posting.goog le.com[/url]

Also, you might want to take a look at 9i CDC (change data capture)
see if it makes life easier for you.


- Jusung Yang


You might want to take a look at CDC (change data capture)
[email]aennen@amdocs.com[/email] (Alan) wrote in message news:<bdcc590d.0212101011.3acce77e@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.