Home » Developer & Programmer » Designer » How to set up foreign keys across 2 schemas
How to set up foreign keys across 2 schemas [message #206377] Wed, 29 November 2006 16:04 Go to next message
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
Re: How to set up foreign keys across 2 schemas [message #206380 is a reply to message #206377] Wed, 29 November 2006 18:07 Go to previous messageGo to next message
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
Re: How to set up foreign keys across 2 schemas [message #206414 is a reply to message #206380] Thu, 30 November 2006 00:13 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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).
Re: How to set up foreign keys across 2 schemas [message #206550 is a reply to message #206414] Thu, 30 November 2006 08:49 Go to previous message
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.....
Previous Topic: Administering Designer Security
Next Topic: migrate from oracle 7.3.4 to oracle 9i or 10g
Goto Forum:
  


Current Time: Fri Mar 29 00:19:59 CDT 2024