Oracle will throw an error if you try to declare a second primary key on a table. If your table has more than one candidate key, you can still enforce the business rules by declaring one as the PRIMARY KEY and the other candidate key is constrained to be UNIQUE and NOT NULL.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.