DDL Import gives the following error: Trying to set comment to a non-existent object (Doc ID 1400579.1)

Last updated on OCTOBER 27, 2016

Applies to:

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

Symptoms

Let's say that we have a model that contains all tables that are referred to in the DDL file.
The DDL file looks as follows:
CREATE TABLE SCOTT.ACS_SR_DEPT_NPS_RATIO (
SERVICE_REGION_ID NUMBER(5) NOT NULL,
DEPARTMENT_ID NUMBER(5) NOT NULL,
)TABLESPACE SCOTT_DATA01;

ALTER TABLE SCOTT.ACS_SR_DEPT_NPS_RATIO MODIFY PERCENT_WHO_GET_NPS_QUESTION CONSTRAINT Validation_Rule_Perc_334835818 CHECK (PERCENT_WHO_GET_NPS_QUESTION BETWEEN 0 AND 100);

COMMENT ON TABLE SCOTT.ACS_SR_DEPT_NPS_RATIO IS 'Created by SCOTT in  January 2012.';

ALTER TABLE SCOTT.ACS_OUTBOUND_SURVEY ADD (
NPS_QUESTION_OFFERED VARCHAR2(1) DEFAULT 'U' CONSTRAINT Check_Constraint_Assignment CHECK (NPS_QUESTION_OFFERED IN ('Y', 'N', 'U')),
NPS_RATIO_USED_AT_SELECT_CALL NUMBER(3) DEFAULT 0 CONSTRAINT Validation_Rule_Per_1576522669 CHECK (NPS_RATIO_USED_AT_SELECT_CALL BETWEEN 0 AND 100)
);

COMMENT ON TABLE SCOTT.ACS_OUTBOUND_SURVEY IS 'Columns NPS_QUESTION_OFFERED, and NPS_RATIO_USED_AT_SELECT_CALL added by SCOTT  in ER January 2012.';

After the DDL import the following error is given:
Trying to set comment to a non-existent object: ACS_OUTBOUND_SURVEY

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