| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Foreign Key to different schema?
Hi!
Please grant 'references' privilege to schema owner of table containing the child table (table on which the foreign key is being defined)
grant references on primary_key_table to schema_owner_of_child_table;
Is it possible to define a foreign key on a table which references a table in a different schema? I tried but got 'insufficient privs' error.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Glenn Travis
INET: Glenn.Travis_at_wcom.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Participate in crazy auctions at http://auctions.rediff.com/auctions/
From: Ura! <ura_at_ymz.yaroslavl.ru>
Date: Mon, 27 Nov 2000 13:15:05 +0300
Subject: WebDB
Hi dear ALL
From: "Rahul Dandekar" <orcldba_at_hotmail.com>
Date: Mon, 27 Nov 2000 08:00:26 -0500
Subject: Re: OCP test resources... SOLVED!!!
I chose 8 track. Worked on 7.x and 8.0 extensively.
I haven't worked on 8i Production Database.
I have only worked on lot of development (DBA of team of 25 developers)
using 8i.
Also, I had all my books for 8.
8i I know many things only theoritically.
Better safe than sorry. I chose 8 path. I would spend $100 extra I know...
-Rahul
> > Dear Rahul, > > Hi! By the by, which track did you take? Oracle8/8i. Please let me > know. > > Regards, > > Ranganath > > > > > "Rahul > Dandekar" To: "L" <ORACLE-L_at_fatcity.com>, "L" > <orcldba_at_hotm <oracledba_at_quickdoc.co.uk> > ail.com> cc: > Subject: Re: OCP test resources... SOLVED!!! > 11/27/00 > 05:54 PM > > > > > > DBAs, > > Following are my experiences about OCP paper 2. > I would not like to attract OCP Police so I won't be disclosing > any questions from the exam... > > I passed. > I scored 59 / 63 wherein passing was 43. > > 1. This exam was pretty simple. Simpler than SQL - PL/SQL exam. > Practical experience would take you a long way and should > be enough to 'pass' this exam. > 2. Some areas which are not commonly touched in routine admin work, > are covered. > 3. Testing environment was similar to Self Test Software Sample test. > 4. I highly recommend the pdf guide at cramsession.com. That was a great > resource. > 5. There were a couple of questions meant just to ensure that noone passes > 100% :) > Questions were very simple and answers I knew for sure. But the> alternatives were
> worked on, > I couldn't have gone wrong. But none of the alternatives were 100% > correct and more > than 1 appeared to be 'best answer'. > 6. I missed one question, which was a jinx, I missed it all the times in > practice > exams also and when I saw it I knew I am gonna miss. Bad preparation. > Worse to know > that you made this mistake 5-6 time and you are making it again. > 7. I missed one question which I could not understand how. ;-) > > Rating of preparation material used... > 1. Notes at cramsession.com - Excellent resource. Very close. > 2. dbasupport.com sample questions - Too simpleReceived on Mon Nov 27 2000 - 06:28:13 CST
 |
 |