DLL Contains Non-Existing Constraint On All Columns In All Tables

(Doc ID 1477975.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer Data Modeler - Version All and later
Information in this document applies to any platform.

Symptoms

When creating DDL, CHECK statement is everywhere: (in all columns in all tables of the current model)

CREATE TABLE BATCH_JOB_EXECUTION
   (
    JOB_EXECUTION_ID NUMBER (19)  NOT NULL CHECK ( SOURCE_IND IN ('A','M')) ,
    JOB_INSTANCE_ID NUMBER (19)  NOT NULL CHECK ( SOURCE_IND IN ('A','M')) ,
    CREATE_TIME TIMESTAMP  NOT NULL CHECK ( SOURCE_IND IN ('A','M')) ,
    START_TIME TIMESTAMP CHECK ( SOURCE_IND IN ('A','M')) ,
    END_TIME TIMESTAMP CHECK ( SOURCE_IND IN ('A','M')) ,
    STATUS VARCHAR2 (10 CHAR) CHECK ( SOURCE_IND IN ('A','M')) ,
    EXIT_CODE VARCHAR2 (20 CHAR) CHECK ( SOURCE_IND IN ('A','M')) ,
    EXIT_MESSAGE VARCHAR2 (2500 CHAR) CHECK ( SOURCE_IND IN ('A','M')) ,
    VERSION NUMBER (19) DEFAULT 1 CHECK ( SOURCE_IND IN ('A','M')) ,
    LAST_UPDATED TIMESTAMP CHECK ( SOURCE_IND IN ('A','M'))

Cause

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