Home » Server Options » Replication » No automatic refresh!!
No automatic refresh!! [message #75305] Sun, 29 December 2002 02:00 Go to next message
Basem Narmok
Messages: 6
Registered: December 2002
Junior Member
I have created a simple replication with snapshots that must refresh each day at 19:00, the tables I have make snapshots on are large ones, one table size not less than 700MB I created snapshot log on the master site and everything worked fine no problem but no automatic refresh the log file just becomes bigger and bigger and each day there is more than 10,000 transaction on the table, the other staring thing that when I EXECUTE DBMS_SNAPSHOT.REFRESH('snapshot') it takes time ++more++ than the creation time of the snapshot!! and for the >700MB master table it just can't refresh not automatic nor manual!!

Any idea/help
Thank you
Re: No automatic refresh!! [message #75306 is a reply to message #75305] Sat, 04 January 2003 11:12 Go to previous message
Basem Narmok
Messages: 6
Registered: December 2002
Junior Member
OK I have checked the DBA_JOBS and giss what I have found??
the NEXT_REFRESH time is set to "01-Jan-4000" !!!
when I create the snapshot it works fine in the first day, but in the next day the NEXT_REFRESH time jumps to "01-Jan-4000", Do any one now whats up?

Any Idea?
Thank you
Previous Topic: Is it possible to up the Server Using Datafiles
Next Topic: Oracle to MS access.
Goto Forum:
  


Current Time: Thu Nov 26 03:14:09 CST 2020