Re: ** outline change

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 20 Mar 2009 11:27:02 -0700
Message-ID: <bf46380903201127h6da657d1rcc2956fc4e8b905d_at_mail.gmail.com>

On Wed, Mar 18, 2009 at 3:14 PM, A Joshi <ajoshi977_at_yahoo.com> wrote:

> Riyaj,
> 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.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 20 2009 - 13:27:02 CDT