No automatic refresh!! [message #75305] |
Sun, 29 December 2002 02:00 |
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 |
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
|
|
|