MySQL Forums
Forum List  »  InnoDB

Error while creating the table in InnoDB
Posted by: krishna reddy
Date: May 07, 2010 12:05AM

Hi,

I am getting the following error while creating the table with more than 70 foreign keys.can u please suggest how to create the table with more than 64 foreign keys.

Is there any way to increase the No of keys?I am using the My SQL 5.5 version.
I am migrating the database from Oracle to My SQL.one of my table in Oracle schema having the 100 foreign keys.I need to use the same table structure with 100 foreign keys.



Edited 1 time(s). Last edit at 05/07/2010 12:06AM by krishna reddy.

Options: ReplyQuote


Subject
Views
Written By
Posted
Error while creating the table in InnoDB
1694
May 07, 2010 12:05AM


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.