Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> References in Designer

References in Designer

From: Eriovaldo do Carmo Andrietta <eca_at_widesoft.com.br>
Date: Mon, 12 Mar 2001 05:08:39 -0800
Message-ID: <F001.002C9708.20010312044022@fatcity.com>

Hi Friends :
 

I have the follow situation working with designer ...
 

I have a table A. The owner´s table is application A, user SCHEMA_A.
This table is shared with application
B.
 

Then
 

I have application B and inside it tables that do references with table A.
 

When i genereate database from server model, it doesn´t genereate for me the correct reference in the script.
 

ALTER TABLE XXX ADD CONSTRAINT     FK_XXX FOREIGN KEY       (FIELD1) REFERENCES A
      (FIELD1)
 

the correct is :
 

ALTER TABLE XXX ADD CONSTRAINT     FK_XXX FOREIGN KEY       (FIELD1) REFERENCES
SCHEMA_A.A
      (FIELD1)
 

Does anyone know how to do it ?
 
 

Eriovaldo do Carmo AndriettaLimeira/SP - Brasil
 

<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">  Received on Mon Mar 12 2001 - 07:08:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US