Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: JusungYang@yahoo.com (Jusung Yang) Newsgroups: comp.databases.oracle.server Subject: Re: Snapshot on a Snapshot Date: 12 Dec 2002 09:57:23 -0800 Organization: http://groups.google.com/ Lines: 21 Message-ID: <130ba93a.0212120957.6180afb9@posting.google.com> References: NNTP-Posting-Host: 64.172.44.14 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1039715843 12340 127.0.0.1 (12 Dec 2002 17:57:23 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 12 Dec 2002 17:57:23 GMT Xref: newsfeed1.easynews.com comp.databases.oracle.server:169534 X-Received-Date: Thu, 12 Dec 2002 11:08:12 MST (news.easynews.com) 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. - Jusung Yang You might want to take a look at CDC (change data capture) aennen@amdocs.com (Alan) wrote in message news:... > 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.