Creating snapshot to refresh everyday at 9:00 pm.

Creating snapshot to refresh everyday at 9:00 pm.

Post by Ben K » Tue, 02 Jun 1998 04:00:00

I am trying to create a snapshot that will automatically
refresh daily at 9:00 pm.  Will the following statement do it?
create snapshot snapshot_name
pctfree 5 pctused 40
tablespace xxx
storage (initial 10M next 1M pctincrease 0)
refresh complete
start with sysdate
next (sysdate+1)+21/24

Please let me know..

*       Ben Kim                     National Futures Asso.        *
*       (847) 699-5000 Ext) 2984    Database Analysis             *

*                            *


1. And you wanted the computer at 9:00 because...

You know when you are right. Keep repeating your message until others get it. Your reputation is solid enough to let you get away with a little nagging. You may help a group find a new director or leader. You have help from friends in high places. Coworkers are interested in your cause. They will help you because you may be helping them in some other capacity. As for others, flirt, but outside of work, of course. Romantic partners may find you captivating and fascinating. Be careful how you use that charm!

RDA Consultants Limited (http://www.RDAConsultants.Com)
Contributing Editor, SQL Server Magazine (

2. IL-Chicago Area-258873--ORACLE-UNIX-Windows NT-Oracle Database Management

3. Chat with FileMaker Inc. TONIGHT (1/14 9:00 PM EST)

4. Read a File into Forms4.5 and Display it


6. Implementing video-utilities?

7. error ORA-01855: AM/A.M. or PM/P.M. required

8. Auto-Installing Btrieve 6.15 Client

9. How refresh dynamic snapshot data?

10. Scheduled Table Refresh - "Snapshot" Replication

11. Snapshots refresh over the Web ?

12. Snapshot not refresh

13. Remote Snapshot Refresh Problem