Fast refresh even after truncating mview log
Hi,
We have lots materialized view in Reporting server (datawarehouse) on which we created mview log on source server for fast refresh. Recently we moved the database to another server using datapump with only metadata.
I have truncated the mview logs on the source, but the mview is getting refreshed with less rows than source.
1 . shouldn't it do full refresh instead of incremental refresh?
2. Do I have to manually drop and recreate the mview ( which is painful)?
3. Will doing complete refresh of all mviews help, but I also want fast refresh to work after complete refresh?
Any suggestion
SOURCE DB version : 11.2.0.1