Reference between two schemas in oracle

Page 1 of 1

[ 1 post ]

Author

Topic

msi_333

Topic subject: Reference between two schemas in oracle

Posted: Tue Sep 29, 2009 12:36 am

Joined: Tue Mar 27, 2007 10:55 pm
Posts: 2103
Location: Earth
Has thanked: 39 time
Have thanks: 57 time

Suppose you have two different schemas in your oracle database management system .Schema A and B.
And suppose your database design drive you to have a foreign key between table x in schema A to a table y in schema B. And this actually the same problem I faced in my system. I made a lot of search on the web until I found the solution.
In schema B you run the following grant access command :

Code:

grant all on y to A;

Now you can run your foreign key add constrains

Code:

ALTER TABLE "x" ADD CONSTRAINT "my_fk" FOREIGN KEY
   ("x_ID")
   REFERENCES B."Y"
   ("ID")
   ;

taking in mind that the schema is a user in oracle database .I wish i helped .

_________________
Currenlty programming with : java , html , php , and javascript . (OCJP-6 certified )

Page 1 of 1

[ 1 post ]

Similar topics
Topic title	Forum	Author	Comments
array in oracle database	Java	aparnaverma	1
130750-Oracle PL/SQL in Bangalore, Pune, Gurgaon	INDIA Jobs	poojak	0
Id reference annotation relationship	JPA	msi_333	0
Passing a Reference Variable	Java	msi_333	0
VB/Oracle Developer-Must be local to Minnesota	USA Jobs	msi_333	0

Codemiles.com » General Topics Forums » General Discussion

All times are UTC [ DST ]

Users browsing similar posts

Users browsing this forum: No registered users and 2 guests

Jump to:

Previous Topic | Next Topic