| Unable to create Materialized view. [message #306173] |
Thu, 13 March 2008 02:28  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
