Materialized view, logs, and fast refresh.

Can someone please give me the correct steps to getting a materialized view to do a fast refresh.

I added primary keys to the table and create the MV log, but I still get an error when trying to  do a fast refresh, i have to do a complete refresh each time, and this table is about 8 gigs on a remote MSSQL server.

Any hellp would be appreciated. Thanks
FutureDBA-Asked:
Who is Participating?
 
Franck PachotConnect With a Mentor Commented:
Yes I'm sure because fast refresh necessitate snapshot logs.

Materialized views is not the solution if you can't do full refresh.
Replication solution such as Golden Gate can acheive that - but not at the same price :(
0
 
FutureDBA-Author Commented:
anyone?
0
 
mlmccCommented:
I don't think I can really help, but the experts who can probably will want to know what the error message is

mlmcc
0
 
Franck PachotCommented:
Hi,
You can use dbms_mview.explain_mview to know the reason that prevent fast refresh.
But if the base table is remote on MSSQL  you can't do fast refresh.
Regards,
Franck.
0
 
FutureDBA-Author Commented:
>> "But if the base table is remote on MSSQL  you can't do fast refresh."

yes, the remote table is remote on MSSQL, are you absolutely sure?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.