Re: Creating snapshots & Rollback implications

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 16 Jan 2001 21:53:24 -0800
Message-ID: <3A653354.25694BD7@exesolutions.com>

> I intend to launch a script to create a number of snapshots.
>
> The script is in the general format -
>
> CREATE SNAPSHOT SNAP_1 AS SELECT * FROM TABLE_1_at_MASTERDB .........
> CREATE SNAPSHOT SNAP_2 AS SELECT * FROM TABLE_2_at_MASTERDB .........
> CREATE SNAPSHOT SNAP_3 AS SELECT * FROM TABLE_3_at_MASTERDB .........
> CREATE SNAPSHOT SNAP_4 AS SELECT * FROM TABLE_4_at_MASTERDB .........
> .
> .
> .
>
> The question is - what are the implications for COMMITing and THUS Rollback
> space?
>
> Is there an implicit COMMIT after each snapshot is created?

Snapshots are self-commiting. As soon as they refresh they commit and free up the rollback segment.

Daniel A. Morgan Received on Tue Jan 16 2001 - 23:53:24 CST