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, Received on Fri Dec 01 2000 - 02:44:58 CST