Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Doubt about Designer 2000
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 Andrietta
eca_at_widesoft.com.br
ICQ #102604225
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: eca_at_widesoft.com.br 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).Received on Thu Mar 15 2001 - 11:17:13 CST
![]() |
![]() |