Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Creating snapshots & Rollback implications

Creating snapshots & Rollback implications

From: John Reilly <john.reilly_at_nospam.bct.co.uk>
Date: Tue, 16 Jan 2001 17:01:16 -0000
Message-ID: <G5%86.1046$UC4.16678@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 - 11:01:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US