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: 2844
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: 25573
Registered: January 2009
Location: SoCal
Senior Member
My car is getting problem.
Tell me how to make it go, please.
Previous Topic: (LOCAL=NO)
Next Topic: Add controlfile in ASM encounter error ORA-00214 ?
Goto Forum:
  


Current Time: Sun Aug 20 19:56:38 CDT 2017

Total time taken to generate the page: 0.01131 seconds