Re: Error With Multiple Foreign Keys in a Table
As the error message told you, you need to have an index those columns before you can create a foreign key, some newer version have this restrictions removed, can't recall which version.
so, you need to first create the follwing 2 index before creating the foreign key constraint
(`call_type_id`) in table gc_call_info
and
(`call_type_id`) in table call_type_list
Subject
Views
Written By
Posted
4068
April 13, 2005 04:03PM
Re: Error With Multiple Foreign Keys in a Table
2138
April 14, 2005 07:59PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.