SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import DDL does not create domains automatically

Bilal HaniffAug 28 2019 — edited Sep 2 2019

I’m importing the following DDL into a model:

CREATE TABLE DWH.dwh_action (
action_name parameter_name NOT NULL,
action_datetime general_date NULL,
description description100 NULL
)

I’ve created the 3 domains manually (however, I expected them to be created automatically), but I still get the following message when importing for RDMS SQL Server 2012.

<<<<>>>>
Null domain occurred while creating dwh_action
Null domain occurred while creating dwh_action
Null domain occurred while creating dwh_action

All 3 domains are not recognised. Any idea how I can fix this ? I have hundreds of tables to import, so assigning the data type manually is not an option.

Added on Aug 28 2019

13 comments

1,305 views