constrain creationg problem on child table [message #311069] |
Thu, 03 April 2008 05:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mm_kanish05
Messages: 493 Registered: January 2007 Location: Chennai
|
Senior Member |
![mm_kanish05%40yahoo.co.in](/forum/theme/orafaq/images/yahoo.png)
|
|
Hello,
I have two tables prcmain,prcitem
previously(old one)
prcmain - prmariykey - unitid,prc_number
prcitem - referencial key - prcmain(unitid,prc_number);
new one (needed)
prcmain - prmariykey - unitid,prc_number,prc_date
prcitem - referencial key - prcmain(unitid,prc_number,prc_Date);
Now
I want to change the primary key of prmain(unitid,prc_number,prc_date) now
First i drop the foreign key in prcitem the old one
and alter the table to add new constrain in prcmain.
which is done properly.
But when i doing referencial constraints in prcitem. im getting problem.
|
|
|
Re: constrain creationg problem on child table [message #311072 is a reply to message #311069] |
Thu, 03 April 2008 06:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
Quote: | But when i doing referencial constraints in prcitem. im getting problem.
|
85 posts and you still post stuff like this? What problem? An error? Unexpected results. Aliens come down and abduct you? The end of life as we know it? Your missing sock turns up (but in a different colour)?
You
|
|
|
|