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 ) ;