OraFAQ Forum: Designer » How to set up foreign keys across 2 schemas

Home » Developer & Programmer » Designer » How to set up foreign keys across 2 schemas

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

How to set up foreign keys across 2 schemas [message #206377]

Wed, 29 November 2006 16:04

suranjita_hajra_7
Messages: 20
Registered: November 2006
Location: Pittsburgh, USA

Junior Member

Hi

I am going to set up a foreign key from a table under schema A to the other table under schema B.
I am getting Oracle Error
Ora-00942, Table or View does not exist.
But this is for sure that the tables highly exist in shemas A and B.
Please help me out.

Thanks a lot in advance.

Regards,
Suranjita

Report message to a moderator

Re: How to set up foreign keys across 2 schemas [message #206380 is a reply to message #206377]

Wed, 29 November 2006 18:07

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You have to grant access to the other schema so that it can see the table.

David

Report message to a moderator

Re: How to set up foreign keys across 2 schemas [message #206414 is a reply to message #206380]

Thu, 30 November 2006 00:13

Littlefoot
Messages: 21648
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Additionally, this privilege should be REFERENCES in order to establish referential integrity constraint. Furthermore, columns must match in number and datatype. Also, master table must have a primary or unique key constraint on this (those) column(s).

Report message to a moderator

Re: How to set up foreign keys across 2 schemas [message #206550 is a reply to message #206414]

Thu, 30 November 2006 08:49

suranjita_hajra_7
Messages: 20
Registered: November 2006
Location: Pittsburgh, USA

Junior Member

Thanks a lot, this really works....
Once again thanks for guiding me.....

Report message to a moderator

Previous Topic:	Administering Designer Security
Next Topic:	migrate from oracle 7.3.4 to oracle 9i or 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 20 06:56:12 CST 2021