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!

Ask : Materialized View without Primary Key ?

HernawanApr 5 2017 — edited Apr 7 2017

hi all,

need advice,

I want to make some MV , the problem is some of our tables not have PK. the old DBA using unique index.

my question :

1. is it possible create MV without PK , any other solution ? ( not using rowid of course)

2. what mean with MV with object id , will clear if using sample. have tried googling but not yet find the clear explaination.

regards

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2017
Added on Apr 5 2017
20 comments
2,006 views