• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

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
0
FutureDBA-
Asked:
FutureDBA-
  • 2
  • 2
1 Solution
 
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
 
Franck PachotCommented:
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now