Originally posted by ckwan
Probably u should try to use the ROWID to create the MV.
Using ROWID is not good for several reasons, it should be avoided.

What is the reason why you do not want to create a PK on that table?