Switch to full style
:rolf:General and off topic threads containing intellectual discussion
Post a reply

Reference between two schemas in oracle

Tue Sep 29, 2009 12:36 am

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 .



Post a reply
  Related Posts  to : Reference between two schemas in oracle
 object reference be cast to an interface reference     -  
 ORACLE/ SQL DBA this is a CTH position. No H1B’s     -  
 array in oracle database     -  
 VB/Oracle Developer-Must be local to Minnesota     -  
 Where do I get Oracle Certification Exam Questions?     -  
 What is your review of Oracle MySQL Certification?     -  
 Downloading & Uploading File through Oracle Database     -  
 130750-Oracle PL/SQL in Bangalore, Pune, Gurgaon     -  
 Reference Parameters     -  
 Method Parameters,,,is it by value or reference???     -