Re: ** outline change
Date: Fri, 20 Mar 2009 11:27:02 -0700
On Wed, Mar 18, 2009 at 3:14 PM, A Joshi <ajoshi977_at_yahoo.com> wrote:
> Thanks for your help. tkprof shows full table scan on the remote
> database. So even if the mlog has 10 entries : it is doing full table scan
> on source table which is big and fts is taking almost one hour .
As the remote table has an MV log table associated with it, a fast refresh is available for many types of MV's.
At this point it might be a good idea to know the following.
What is the specified refresh method for the MV?
Does it use PK or ROWID?
If the MV is considered 'complex', it cannot be fast refreshed. http://download.oracle.com/docs/cd/B19306_01/server.102/b14226/repmview.htm#BABEEHGJ
Posting the code to create the MV might be a good idea.
Certifiable Oracle DBA and Part Time Perl Evangelist