Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Snapshot refreshes
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