Home » SQL & PL/SQL » SQL & PL/SQL » Referential integrity between 2 tables in different schema
Referential integrity between 2 tables in different schema [message #304686] Thu, 06 March 2008 03:19 Go to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
there are 2 tables each in a different schema.
 
can we create a referential integrity between 2 tables in different schema?
 
can any one please help me out?
Re: Referential integrity between 2 tables in different schema [message #304690 is a reply to message #304686] Thu, 06 March 2008 03:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes. And this is not an expert question.

It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Follow them.

Regards
Michel


Re: Referential integrity between 2 tables in different schema [message #304701 is a reply to message #304686] Thu, 06 March 2008 05:00 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What kind of help do you need? Did you study use of the referential integrity constraint? Did you try to create foreign keys between two tables in the same schema? Did it succeed?

Did you do a step further and tried to create foreign keys between two tables in different schemas? What happened?

Post what you've done to accomplish this task (copy and paste the whole SQL*Plus session; follow instructions given in the OraFAQ Forum Guide to properly format the code).
Re: Referential integrity between 2 tables in different schema [message #304935 is a reply to message #304701] Fri, 07 March 2008 04:28 Go to previous messageGo to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
Sorry Michal cadot , I am very new to this forum so i don't know where i should post my query.

I don't know how to create referential integrity between two Schema. can any one please tell me how to create between two schema?
Re: Referential integrity between 2 tables in different schema [message #304938 is a reply to message #304935] Fri, 07 March 2008 04:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you are new to a forum and and see a warning saying don't post there, you post there, weird!

What in the constraint syntax don't you understand?

Regards
Michel

Re: Referential integrity between 2 tables in different schema [message #304940 is a reply to message #304935] Fri, 07 March 2008 04:45 Go to previous message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
gurupatham wrote on Fri, 07 March 2008 11:28
Sorry Michal cadot , I am very new to this forum so i don't know where i should post my query.

I don't know how to create referential integrity between two Schema. can any one please tell me how to create between two schema?


Take a look at the documentation on FOREIGN KEY CONSTRAINTS.
And you might have a look at GRANT too, because you'll be needing that one too.
Previous Topic: ORA-00928: missing SELECT keyword
Next Topic: Convert CLOB to VARCHAR2 in MV
Goto Forum:
  


Current Time: Wed Feb 19 02:39:26 CST 2025