OraFAQ Forum: Server Administration » Foreign Key/Primary Key Problem

Home » RDBMS Server » Server Administration » Foreign Key/Primary Key Problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Foreign Key/Primary Key Problem [message #374061]

Wed, 23 May 2001 02:51

Arindam Malakar
Messages: 12
Registered: May 2001

Junior Member

Hi All,

I am Having the following problem:

In Table A I have defined Primary Key(p,q)
p,q=two attributes of the table.

Now,I want to define Table B such that p will be the foreign key.So I have to define the attribute p of Table B by referencing Table A.

But while defining Table B,it is giving the error:
p must be primary key or unique key.

Whether it is possible to do any way.Please help me.Waiting for the earliest reply.

With regards,

Arindam Malakar

Report message to a moderator

Re: Foreign Key/Primary Key Problem [message #374063 is a reply to message #374061]

Wed, 23 May 2001 04:11

Rakesh Goel
Messages: 8
Registered: May 2001

Junior Member

as A.p column still can have more then one value, therefore you cannot set reference on this column in table B till you don't define it as primary key in table A
If you find anyway then please let me know

Report message to a moderator

Re: Foreign Key/Primary Key Problem [message #374064 is a reply to message #374061]

Wed, 23 May 2001 04:25

Sachin Patil
Messages: 7
Registered: May 2001

Junior Member

I didn't get it( your query)
What do you want to say?

Report message to a moderator

Re: Foreign Key/Primary Key Problem [message #374084 is a reply to message #374061]

Thu, 24 May 2001 01:36

vinay_satya
Messages: 1
Registered: May 2001

Junior Member

Hi,

I think it is NOT possible since p and q are the combination PK in table A.
You cannot take p alone for referincing, need to take both p and q from table A to table B .

-Vinay

Report message to a moderator