Home » Server Options » Replication » Unable to create Materialized view. (
Unable to create Materialized view. [message #306173] Thu, 13 March 2008 02:28 Go to next message
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
Hello Everybody,

I have to create a materialized view for a table which does not have index on any field.
While creating a Mview i am getting an error "TABLE DOES NOT HAVE THE PRIMARY KEY CONSTRAINT".

application developers do not want to create an index on the base table onto which MView is to be created.

Please suggest me is there any way to create a materialised view for the table without index, or is it necessary to have the index on the base table before creating MView on it.

Any suggestion will be Highly appreciated.

Thank you.
Re: Unable to create Materialized view. [message #306182 is a reply to message #306173] Thu, 13 March 2008 03:04 Go to previous message
Michel Cadot
Messages: 63956
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Previous Topic: Initial synch of CDC subscriber
Next Topic: snapshots
Goto Forum:

Current Time: Fri Oct 28 19:03:02 CDT 2016

Total time taken to generate the page: 0.08595 seconds