3 Replies Latest reply on Feb 2, 2014 2:31 PM by thatJeffSmith-Oracle

    Field sizes do not appear in DDL

    60cddf57-344c-4007-b04e-cd7f7e490eaf

      Despite using this to generate SQL Server data models, when I use domain fields whereby I have specified VARCHAR2(100 CHAR) for example, when I run Export DDL the script is generated with the field sizes missing for Oracle databases (11g). This makes it almost useless.

       

      CREATE TABLE MDWH.PARTITION_KEY

        (

          PARTITION_KEY VARCHAR2 NOT NULL ,

          REPORTING_DATE DATE

        ) ;

      CREATE UNIQUE INDEX MUSI_MDWH.PK_PARTITION_KEY ON MUSI_MDWH.PARTITION_KEY

        (

          PARTITION_KEY ASC

        )

        ;

        ALTER TABLE MUSI_MDWH.PARTITION_KEY ADD CONSTRAINT PARTITION_KEY_PK PRIMARY KEY ( PARTITION_KEY ) ;