Database Design Transformer (DDT) Does Not Generate Sequence for Surrogate Key Columns

(Doc ID 852362.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Designer - Version: 6.5 to - Release: Designer 6i to Designer 10g
Information in this document applies to any platform.


Problem Statement:
The problem relates to the transformation of entities into tables, when the Database Design Transformer (DDT) is set to create surrogate key columns for all tables resulting from the transformation. It is documented that when this Transformer setting is selected, the DDT automatically adds a surrogate key column to the table transformed from the entity, and an Oracle sequence is automatically created and associated with newly-added surrogate key column. You can also opt to create a domain into which all surrogate key columns created by the DDT will be included.

Problem Scenario:
Following the documented process for the automatic creation of a surrogate key column and sequence during the transformation process does not produce the anticipated sequence number.

Business Impact:
The sequence will therefore need to be manually created and associated with the surrogate key columns. But this is prone to error and omission, and breaks the requirements traceability from the logical model to the physical model.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms