Re: How smart are Snapshots ?

Heber Ferraz-Leite wrote:

> I was just wondering how smart Oracle behaves in the create snapshot
> statement.
>
> When I say "update snapshot", will Oracle basically copy the whole
> table again, or will it be smart enough to know where the table has
> been changed since the last update snapshot and only copy whatever has
> been changed ?

By default, it will copy the whole table - but you can create a 'snapshot log', which is possible for all 'not-complex-
snapshots'.

by, jm

-- 
SIG: In a world without fences, who needs gates.