Re: ERROR 1005: Can't create table (errno: 121) Help
This error occurs when a foreign key constraint for the same field exist.
For Me I had product table and subcattable.
In subcattable I had a foreign key constraint of cascade delete on productid in product table.
I renamed both the tables and tried to create fresh product table and subcattable. Product table was created properly but subcattable gave the error Can't create table (errno: 121)
I deleted the renamed subcattable. Then it was fine
Subject
Views
Written By
Posted
324538
July 12, 2005 11:49AM
145372
July 18, 2005 10:12PM
133750
July 19, 2005 12:37AM
89277
March 15, 2006 06:35AM
70581
December 20, 2007 03:05PM
118160
March 15, 2006 03:17PM
39902
May 05, 2006 10:49AM
16727
December 11, 2008 04:29AM
17919
August 30, 2006 07:00AM
16440
September 03, 2006 05:50AM
16552
September 03, 2006 10:47AM
13077
May 29, 2007 05:25AM
16317
October 25, 2007 08:21AM
10305
February 19, 2009 08:39AM
10942
June 08, 2007 10:41AM
10416
March 23, 2006 04:07PM
8684
July 06, 2006 10:02AM
8797
July 26, 2006 03:34PM
8031
September 19, 2007 04:47AM
10970
September 12, 2006 12:53PM
Re: ERROR 1005: Can't create table (errno: 121) Help
9460
June 06, 2007 07:37AM
13428
March 06, 2008 06:22PM
8470
April 25, 2008 02:07PM
5701
January 28, 2009 05:16AM
16524
February 23, 2009 07:16PM
7696
April 28, 2009 01:06AM
16873
May 22, 2009 09:04AM
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.