| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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 enabled foreign
Dear Ranganath,
You would have given 'on delete cascade ' while creating foreign key
relationship which takes cares of deleting the detail table records when you
issue an delete command for the master table. This does not happens in
truncate.
Regards
Raji
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
RanganathK_at_lgcommerznow.com
Sent: Friday, December 01, 2000 2:15 PM
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 Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.211 / Virus Database: 100 - Release Date: 11/14/00
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.211 / Virus Database: 100 - Release Date: 11/14/00
Received on Tue Dec 19 2000 - 03:31:24 CST
 |
 |