Total members 11892 |It is currently Sun Sep 22, 2024 6:38 am Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka






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 .



_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 1 post ] 

  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?     -  
 130750-Oracle PL/SQL in Bangalore, Pune, Gurgaon     -  
 Downloading & Uploading File through Oracle Database     -  
 Reference Parameters     -  
 Method Parameters,,,is it by value or reference???     -  










Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com