Home » RDBMS Server » Server Administration » constrain creationg problem on child table
constrain creationg problem on child table [message #311069] Thu, 03 April 2008 05:58 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

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 messageGo to next message
pablolee
Messages: 2834
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
Re: constrain creationg problem on child table [message #311126 is a reply to message #311069] Thu, 03 April 2008 08:39 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
My car is getting problem.
Tell me how to make it go, please.
Previous Topic: ORA-03135: connection lost contact error
Next Topic: Installing Oracle text, xml extension and enterprise manager
Goto Forum:
  


Current Time: Wed Dec 07 22:21:30 CST 2016

Total time taken to generate the page: 0.19214 seconds