Home » Server Options » Replication » Unable to create Materialized view. (10.1.0.5.0/HPUX)
Unable to create Materialized view. [message #306173] Thu, 13 March 2008 02:28 Go to next message
it_me24
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: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CREATE MATERIALIZED VIEW, see create_mv_refresh, WITH ROWID.

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


Current Time: Thu Mar 28 10:13:38 CDT 2024