Re: Snapshot

From: Frank <franjoe_at_frisurf.no>
Date: Wed, 4 Apr 2001 18:37:42 +0200
Message-ID: <z5Iy6.4102$R6.87058@news1.oke.nextra.no>

Hi!

Do you mean something like
TO_DATE('20010405220000','YYYYMMDDHH24MISS') any expression returning a DATE type can be used (have not tried "home made" functions though)

NB:MY_SNAP?HOT :-) Frank

André Klos <andre.klos_at_pikon.com> wrote in message news:9afar5$j9p$1_at_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 - 11:37:42 CDT