Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[4.2EA2] Show sql for table error

jnp1234Jan 12 2017 — edited Jan 16 2017

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

                                 ^^^                

pastedImage_0.png

Does show the sql after clicking ok.

This did not happen in 4.1.x.

SQL Developer Version 4.2.0.16.356

Comments

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.

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:

pastedImage_0.png

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

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 13 2017
Added on Jan 12 2017
2 comments
344 views