Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA - 02266 -unique/primary keys in table referenced by enabl
The foreign key probably has the "on cascade delete" option enabled.
Check to see if all of the child records that relate to the prod_master
record got deleted as well. This option does not work with truncate
(because of how truncate processes the transaction it can't account for
referential integrity, so it will not allow you to truncate a table if any
other table is "actively" references it). HTH
Jeffery Stevenson
Chief Database Geek
Medical Present Value, Inc.
Austin, TX
-----Original Message-----
From: RanganathK_at_lgcommerznow.com [mailto:RanganathK_at_lgcommerznow.com]
Sent: Friday, December 01, 2000 2:45 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA - 02266 -unique/primary keys in table referenced by enabled
foreign
Dear DBA Gurus,
I have a question for you which may sound trivial. I beg a pardon if it sounds basic to anyone for having asked it. I have two tables by name prod_master and prod_details. They are master and detail tables respectively i.e. there is a foreign key relationship between these two tables with some data in both the tables. When I try to issue the statement truncate table prod_master it is giving the above mentioned error where as when I issue the statement delete from prod_master and then issue commit I am able to delete the records. How is it happening? This occurs even if I delete all the records from the detail table. Can anybody explain me as to why this is happening? Any views in this regard will be highly appreciated.
TIA and regards,
Ranganath
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: RanganathK_at_lgcommerznow.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Dec 01 2000 - 07:58:44 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |