2 Replies Latest reply on Jul 4, 2016 3:52 PM by user1094672

    Bug Report: SQL Developer Data Modeler Sync getting wrong default type

    user1094672

      I have a model in data modeler which has a default value of 'N', but the generated DDL to sync this to the existing data dictionary/database keeps saying to set the default value to 'Y'.   SQL Developer 4.1.3.20.

       

      Screen Shot 2016-07-03 at 11.10.32 PM.png

      After manually updating the table in the database to have the correct default of 'N', and re-running the sync, I get a difference in the "physical details" section which was not there before:

       

      Screen Shot 2016-07-03 at 11.31.52 PM.png

      Can anyone explain what's going on, or is this a bug?

        • 1. Re: Bug Report: SQL Developer Data Modeler Sync getting wrong default type
          thatJeffSmith-Oracle

          we need to see your table's original DDL code

           

          also, your version of Oracle and your version of SQL Developer

           

          finally, bug reports should be sent to My Oracle Support, although we try to help people here as much as reasonable

          • 2. Re: Re: Bug Report: SQL Developer Data Modeler Sync getting wrong default type
            user1094672

            Hi Jeff,

             

            Thanks for getting back to me. The version of SQL Developer is SQL Developer 4.1.3.20.


            Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production   

            PL/SQL Release 11.2.0.4.0 - Production                                        

            CORE 11.2.0.4.0 Production                                                    

            TNS for Linux: Version 11.2.0.4.0 - Production                                

            NLSRTL Version 11.2.0.4.0 - Production                                        

             

              CREATE TABLE "RS3"."APPROVAL_ASSAYS"

              ( "RECORD_ID" NUMBER(8,0) NOT NULL ENABLE,

              "POLICY_ID" NUMBER(8,0) NOT NULL ENABLE,

              "ASSAY_ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,

              "ASSAY_NAME" VARCHAR2(256 BYTE),

              "IS_ARCHIVED" VARCHAR2(1 BYTE) DEFAULT 'N' NOT NULL ENABLE,

              "INSERTED_DATE" DATE DEFAULT sysdate NOT NULL ENABLE,

              "INSERTED_BY" NUMBER(8,0) NOT NULL ENABLE,

              "ARCHIVED_DATE" DATE,

              "ARCHIVED_BY" NUMBER(8,0),

              CONSTRAINT "PK_APPROVAL_ASSAYS" PRIMARY KEY ("RECORD_ID")

              USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

              STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

              PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

              BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

              TABLESPACE "RIS_DATA"  ENABLE,

              CONSTRAINT "FK_AA_AP" FOREIGN KEY ("POLICY_ID")

              REFERENCES "RS3"."APPROVAL_POLICIES" ("POLICY_ID") ENABLE

              ) SEGMENT CREATION IMMEDIATE

              PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

            NOCOMPRESS LOGGING

              STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

              PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

              BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

              TABLESPACE "RIS_DATA" ;