In both cases the refresh works okay. The data is refresh perfectly.
The only problem is, that if you refresh fast, the all_mview-view says that a 'COMPLETE' refresh took place (or isn't he telling the truth? In that case it could be working correct and I'm on a wild goose chase...) Is there a different view that states which type of refresh method was used?? That could verify it for me.
This is really wierd: I specially updated Oracle to the latest patch level (8.1.7.4.9) because there were bugs with replication.
The data I must replicate is about 9gig and the tables have multiple indexes. (okay, i can recreate indexes on the replicatie-db, I know)
Is there another way to replicate the data? I thought that snapshots would do the trick. The replication data is only for reporting. But the reports need data that is as current as it can be, so many refreshes during the day will be needed.
I only have tomorrow to solve this problem... oh-ohhh 
There goes my evening...
Thanks sofar, but keep those comments comming!!
Erik
Last edited by efrijters; 06-19-2003 at 11:04 AM.
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
Reply With Quote