Re: Unable to recreate table with engine other than MyISAM
Posted by:
Rob Kroese
Date: April 15, 2009 10:43AM
I have this same problem. I drop the database, recreate it, and try to create a table called 'Locations', and I get an error 150. There is no FK problem -- there are no keys (or anything else for that matter) in the database. When I set the engine to MyISAM, it works. Not sure if that's because the table used to be MyISAM and it 'remembers', or if there is some phantom FK it's hitting and it doesn't have a problem when I create the table as MyISAM because MyISAM doesn't support FKs.
Anyone have a solution? Maybe a way to clean out all artifacts of the old db?
Subject
Views
Written By
Posted
6047
October 30, 2007 01:10PM
3171
November 15, 2007 02:03AM
Re: Unable to recreate table with engine other than MyISAM
2707
April 15, 2009 10:43AM
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.