This discussion is archived
1 Reply Latest reply: Nov 20, 2012 4:27 AM by Philip Stoyanov RSS

3.3EA1 Discover Foreign Keys not applying FK naming template properly

Kent Graziano Oracle ACE Director
Currently Being Moderated
I reverse engineered in another schema (381 tables). It has PK but no FKs so I decided to use the Discover Foreign Keys utility (whihc seems to work fine overall),. The proble is that it did nto quite name the FKs correctly.

My template is {child}_FK{seq nr}

What I get is:
RTMRMID0_TM_ROUTED_MED_FK2

What I should get is:
RTMRMID0_TM_ROUTED_MED_FK1

Further if there is more than one on a table I get this:
RTMRMID0_TM_ROUTED_MED_FK2
RTMRMID0_TM_ROUTED_MED_FK2v1

See the problem?

If I then run use the Naming Rules button on the table dialog, the template is applied correctly!

So I surmise the issue is in the Discover FK utility code.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points