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
Information in this document applies to any platform.
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,
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document