Re: New to Designer...where to start with incomplete defines of FK constraints?

You have entities that do not have UID, which results in tables taht don't have columns in the resulting primary key constraints. You should find that all of the FK that have problems refer to PK that also have problems.

Two solutions. The best is to make sure all entities have UIDs defined.

The second is an option on the last tab of the DDW dialog which will cause the DDW to create artificial PK columns for entities without UIDs.

kgrigg_at_acxiom.com (Kelly) wrote:

>Hi all,
>I am new to Designer 2000 and Oracle. I am running it with Personal Oracle
>7.3 for testing. I have created my entities, and used Database Wizard to
>create DD diagram. The report from the Table Quality control looks pretty
>good except for a list of constraints without colums. I can see that it is
>mostly foreign key constraints with a few primaries too. Can anyone give me
>some direction on where to find info on how to go about fixing this problem?
>I'm not experienced with all the automation....can anyone give me a good
>starting place?
>
>TIA!!
>
>Kelly
>
>ps. Please CC by mail too....our connection to the newsserver here is a bit
>flakey.....
>
>
>"If you've had half as much fun as me...
> ....Then I've had twice as much fun as you!!"
>
>kgrigg_at_acxiom.com
>cayenne_at_cei.net
>
>Visit my Website at: http://www.cei.net/~cayenne/index.html

-JJ

 Jeffrey Jacobs & Associates
 Oracle Designer/2000 Consulting & Training  951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 415-571-7092, FAX: 800-665-1379
 Email: jmjacobs_at_ix.netcom.com Received on Mon Jul 14 1997 - 00:00:00 CDT