This discussion is archived
3 Replies Latest reply: Sep 13, 2013 5:30 AM by user11141303 RSS

Wrong DDL Script gets generated.

user11141303 Newbie
Currently Being Moderated

Hi,

I am using Oracle Data Modeler 3.2.20.09.87.

Steps I followed:

USER A:

1. Created Entity say T_EMPLOYEE and an attribute in it say EMP_ID.

2. Created a Domain CODE VARCHAR(10).

3. Assigned EMP_ID to Domain CODE

4. Moved my project to subversion.

 

USER B:

1. Checked out the project.

-- USER B do not have Domain CODE defined in his SQL Modeler

2. Ran all Entities and Relational Design rules

-- gets Design OK

3. Generated DDL Script.

4. Below script gets generated:

    Create Table T_EMPLOYEE (

                EMP_ID varchar2  

                 );

-- Varchar size of EMP_ID is not appearing in project logical model and relational model, nor it is there is DDL script as Domain CODE is not available with USER B Modeler.

 

Question:

1. How to avoid such mistake as even design Rules is not able to check it ?

2. Is it a bug or I am doing some mistake?

 

Regards

Legend

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