Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshot Logs/Triggers
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 emailReceived on Tue Nov 27 2001 - 10:07:45 CST