Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Primay Key Materialized View

SID3Jan 24 2011 — edited Jan 24 2011
I have question on primary key materialized view. Is is mandatory to use the "WITH PRMARY KEY" clause to create a primary key mview.

From what i have heard i think its mandatory.

But many of the online docs that i have vsitied .. i see no mention of WITH PRIMARY KEY clause. I am bit confused.

Please advice.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2011
Added on Jan 24 2011
3 comments
889 views