Skip to Main Content
Forums

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!

One to One relationship

mohitanchliaSep 27 2009 — edited Sep 28 2009
Oracle 11.0.1.7:

Is it ok to have foreign key as primary key in one to one relationship? Is there any drawbacks? I have 2 options:

1. Create sequence primary key
2. Or make foreign key as primary key

Which one is better and why? I like # 2 just because I don't have to create extra index, sequence and column.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2009
Added on Sep 27 2009
#general-database-discussions
7 comments
998 views