2 Replies Latest reply on Jan 16, 2017 9:10 AM by jnp1234

    [4.2EA2] Show sql for table error

    jnp1234

      Choosing to see the sql for a table gives the following Error:

       

       

      /*** Syntax Error at line 19, column 37

       

       

        PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

                                           ^^^                

       

      Does show the sql after clicking ok.

       

      This did not happen in 4.1.x.

       

      SQL Developer Version 4.2.0.16.356

        • 1. Re: [4.2EA2] Show sql for table error
          thatJeffSmith-Oracle

          Can you share the entire SQL?

           

          If i generate the DDL for EMPLOYEES, i have 7 instances of 'INITRANS 2 MAXTRANS' in the code, with no errors produced.

          • 2. Re: [4.2EA2] Show sql for table error
            jnp1234

            The ddl producing the error is like (I can't post the exact ddl here):

              CREATE TABLE "ZZZZZZ"

               (    "ID" NUMBER NOT NULL ENABLE,

                "CREATEDTIME" DATE,

                "CHANGEDTIME" DATE,

                "STATUS" VARCHAR2(16 BYTE) DEFAULT 'READY',

                .... columns deleted

                 CONSTRAINT "ZZZZZZ_PK" PRIMARY KEY ("ID")

              USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

              STORAGE(INITIAL 268435456 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645

              PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

              BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

              TABLESPACE "ZZZ_I_8M"  ENABLE

               ) SEGMENT CREATION IMMEDIATE

              PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

            NOCOMPRESS LOGGING

              STORAGE(INITIAL 262144 NEXT 268435456 MINEXTENTS 1 MAXEXTENTS 2147483645

              PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

              BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

              TABLESPACE "ZZZ_T_256M"

            LOB ("MESSAGE") STORE AS BASICFILE (

              TABLESPACE "ZZZ_I_8M" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10

              NOCACHE LOGGING

              STORAGE(INITIAL 262144 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645

              PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

              BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;

             

             

             

            I also have this ddl producing an error:

             

              CREATE TABLE "TAX_ACCOUNT_BULK_CNT"

               (    "BULK_NUMBER" NUMBER,

                "CHANGEDTIME" DATE

               ) SEGMENT CREATION IMMEDIATE

              PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

            COMPRESS FOR OLTP LOGGING

              STORAGE(INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 2147483645

              PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

              BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

              TABLESPACE "FX_T_256K" ;