Re: Snapshot on a Snapshot

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 11 Dec 2002 11:53:39 -0800
Message-ID: <at8543012e8@drn.newsguy.com>

In article <bdcc590d.0212101011.3acce77e_at_posting.google.com>, aennen_at_amdocs.com 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; Received on Wed Dec 11 2002 - 13:53:39 CST