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: 65146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Previous Topic: Replication solutions with Oracle 8i
Next Topic: snapshots
Goto Forum:

Current Time: Mon Aug 21 03:35:45 CDT 2017

Total time taken to generate the page: 0.07993 seconds