Home » Server Options » Replication » Fast Refresh using two non-primary key tables
Fast Refresh using two non-primary key tables [message #228878] Wed, 04 April 2007 08:18 Go to next message
rksudhakar
Messages: 2
Registered: April 2007
Junior Member
Hi,

I have a materialized view based on two tables with an outer join clause. Both the tables do not have a primary key so I had created materialized view log with row-id on each of them but still I am not able to bring out the fast refresh option for the materialized view. My question is can I have a fast refresh option for materialized view built from two tables without primary keys and having an outer join clause????. If possible please send me some sample scripts for quicker understanding.

Thanks and Regards,
Sudhakar

Report message to a moderator

Re: Fast Refresh using two non-primary key tables [message #228925 is a reply to message #228878] Wed, 04 April 2007 09:48 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member
hi,

hope this helps

regards,
shanth

Report message to a moderator

Re: Fast Refresh using two non-primary key tables [message #228979 is a reply to message #228925] Wed, 04 April 2007 14:39 Go to previous message
rksudhakar
Messages: 2
Registered: April 2007
Junior Member
Hi,

Thanks for the quick reply. But I do not get examples of materialized view on two non primary key tables. If someone has any link or resource please share.

Thanks,
Sudhakar

Report message to a moderator

Previous Topic: oracle9i Replication
Next Topic: materialized view - invalid status
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 22:10:36 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.