| 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 enabl
You cannot truncate a table with a foreign key.
-----Original Message-----
From: RanganathK_at_lgcommerznow.com [mailto:RanganathK_at_lgcommerznow.com]
Sent: Friday, December 01, 2000 12: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-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). Received on Fri Dec 01 2000 - 10:02:31 CST
 |
 |