Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshot Logs/Triggers

Re: Snapshot Logs/Triggers

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Tue, 27 Nov 2001 16:07:45 GMT
Message-ID: <3c03ba02.2398538826@news.globix.com>


snapshots work out good for us..
snapshots, btw, involve triggers created on the background to update snapshot log.. snapshot log keeps track of inserted/updated/deleted rows..
I refresh snapshots every hour.. results in a couple of thousands of rows.. takes few min.. not a big hit on production system.

On Tue, 27 Nov 2001 22:20:01 +1100, Casey Dyke <cdyke_at_froggy.com.au> wrote:

>Folks,
>
>Am curious to know what setup others may have employed when trying to
>shift incremental data (ie: only that that has changed) from one
>instance to the next (prod --> reporting). Snapshot logs or triggers
>quite easily facilitate this, but come at a cost. Has anyone avoided
>them due to said cost and, if so, how'd you dig out?
>
>:-)

.......
We use Oracle 8.1.6-8.1.7 on Solaris 2.6, 2.7 boxes

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email
Received on Tue Nov 27 2001 - 10:07:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US