Quote Originally Posted by PAVB
Please take a look at your MV creation statement...



...and then take a look a Oracle documentation you have quoted...
Why doesn't Oracle give me an error message when I do this and why does it create the materialized view with primary key?