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
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.
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" ;
