Home » Server Options » Replication » How to create materialized view
How to create materialized view [message #129291] Sat, 23 July 2005 05:16 Go to next message
jigneshshah
Messages: 7
Registered: June 2005
Location: Pune
Junior Member
I have a table without any key on one instance. using dblink i need to create the materialized view with refresh fast on commit option. so that whenever the master data get change , change will take place. Is there any constraint that the table should have a Primary key ? i did not find any solution ? can some one help me out with proper example...

Report message to a moderator

Re: How to create materialized view [message #129324 is a reply to message #129291] Sun, 24 July 2005 02:22 Go to previous message
Frank Naude
Messages: 4596
Registered: April 1998
Senior Member
As far as I understand one cannot use "ON COMMIT" across a database link.

Best regards.

Frank

Report message to a moderator

Previous Topic: Create Materialized View locking source table
Next Topic: Materialized view for View
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 23 02:21:31 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.