foreign key in partition
Dear Sir/Madam
I have make the partition on table this table consist of the many foreign key from other table primary keys and another this table primary key familiar with another table such as a foreign key
When making then show the error:---
#1217 --> Cannot delete or update a parent row: a foreign key constraint fails
in short can we make the partition in foreign key tables
Subject
Views
Written By
Posted
foreign key in partition
4247
December 24, 2010 06:02AM
1754
December 24, 2010 11:09AM
1575
December 25, 2010 01:25AM
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.