Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Creating snapshots & Rollback implications
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 ShawReceived on Tue Jan 16 2001 - 11:01:16 CST