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
324560
July 12, 2005 11:49AM
145386
July 18, 2005 10:12PM
133756
July 19, 2005 12:37AM
89282
March 15, 2006 06:35AM
70586
December 20, 2007 03:05PM
118229
March 15, 2006 03:17PM
39911
May 05, 2006 10:49AM
16740
December 11, 2008 04:29AM
17926
August 30, 2006 07:00AM
16444
September 03, 2006 05:50AM
16557
September 03, 2006 10:47AM
13084
May 29, 2007 05:25AM
16322
October 25, 2007 08:21AM
10322
February 19, 2009 08:39AM
10946
June 08, 2007 10:41AM
10421
March 23, 2006 04:07PM
8693
July 06, 2006 10:02AM
8806
July 26, 2006 03:34PM
8037
September 19, 2007 04:47AM
10975
September 12, 2006 12:53PM
Re: ERROR 1005: Can't create table (errno: 121) Help
9469
June 06, 2007 07:37AM
13432
March 06, 2008 06:22PM
8476
April 25, 2008 02:07PM
5707
January 28, 2009 05:16AM
16530
February 23, 2009 07:16PM
7698
April 28, 2009 01:06AM
16880
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.