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...
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: 4410
Registered: April 1998
Senior Member
As far as I understand one cannot use "ON COMMIT" across a database link.

Best regards.

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


Current Time: Sat Apr 19 10:44:46 CDT 2014

Total time taken to generate the page: 0.05550 seconds