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!

creating multiple unique key

135084Jan 29 2003 — edited Jan 31 2003
Hello I have a table with one sequence id (RT_ID) as Primary key and have several other column such as route_type, route_number, route_signing,road_number,county_id_fk,muni_id_fk,effective date and some more. I would like to create three unique key as follows
1) route_number,route_signing,effective_date
2) road_number,county_id_fk,route_signing,effective_date
3) road_number,muni_id_fk,route_signing,effective_date

But it does not work . I can create first record with no problem , but when trying to create a unique record for second unique key it gives me error for third unique key.

Is there a problem in this design because some of the columns are shared in all kind of unique key.? Do I have to create three seperate tables for every unique key ?

thanks

Suhail
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2003
Added on Jan 29 2003
12 comments
719 views