Re: Creating snapshots & Rollback implications

As create snapshot is a DDL command there is an implicit commit.

Hth,

Sybrand Bakker, Oracle DBA

"John Reilly" <john.reilly_at_nospam.bct.co.uk> wrote in message news:G5%86.1046$UC4.16678_at_news6-win.server.ntlworld.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?
>
> Thanks in advance for any help.
>
> --
> John
>
> (Remove NOSPAM to reply)
> ------------------------------------------------
>
> "Reasonable people adapt themselves to the world. Unreasonable people
> attempt to adapt the world to themselves. All progress, therefore, depends
> on unreasonable people."
> -George Bernard Shaw
>
>
>
Received on Tue Jan 16 2001 - 12:13:10 CST