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 refreshes

Re: Snapshot refreshes

From: cmcdermo_mindspring <cmcdermo_at_mindspring.com>
Date: Thu, 28 Oct 1999 23:48:05 -0400
Message-ID: <381918F5.DD1D70D8@mindspring.com>


Sounds like you are describing the snapshot log functionality. A 'feature' of complete refreshes is that row data is unavailable during the refresh process. Oracle truncates the snapshot table during a complete refresh which, in larger tables, makes data unavailable for a period of time. The best solution is to create a snapshot log (CREATE SNAPSHOT LOG ON <table_name>) on the master table and change the snapshot type to 'fast'. This will cause a refresh to simply update the snapshot table with the deltas from the master table and leave the row data available during refresh.

Chris

mikestreeton_at_my-deja.com wrote:

> Can anybody tell me if complete refreshes of snapshots are
> transactional or can be made transactional i.e. delete old rows and
> insert new rows with one transaction. We have a problem with a complete
> refresh snpashot that seem to have 0 rows in it when it is being
> updated.
>
> Many Thanks
>
> Mike
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 28 1999 - 22:48:05 CDT

Original text of this message

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