Snapshot

From: André Klos <andre.klos_at_pikon.com>
Date: Wed, 4 Apr 2001 16:29:42 +0200
Message-ID: <9afar5$j9p$1@piesbach.saarnet.de>

Hi!

How can I indicate a certain date for creating a Snapshots instead of the instruction " sysdate "?

create snapshot MY_SNAPHOT
storage (initial 100K next 100K pctincrease 0) tablespace MY_TABLESPACE
refresh complete

start with SysDate next SysDate+7                    <-- this line

with ROWID
as
select * from MY_TABLE_at_MY_CONNECT

Thanks

André Klos Received on Wed Apr 04 2001 - 09:29:42 CDT