Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> References in Designer
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
![]() |
![]() |