The following table is created:
CREATE TABLE TEST_STO
(
COL1 VARCHAR2(32 CHAR) NOT NULL,
COL2 VARCHAR2(4 CHAR) NOT NULL,
COL3 VARCHAR2(4 CHAR) NOT NULL,
COL4 DATE NOT NULL
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 112K
NEXT 128K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
RESULT_CACHE (MODE DEFAULT)
NOPARALLEL
MONITORING
ENABLE ROW MOVEMENT;
When using Generate SQL | Create Script, the following script is generated:
CREATE TABLE "USER"."TEST_STO"
(
"COL1" VARCHAR2(32 CHAR) NOT NULL ENABLE,
"COL2" VARCHAR2(4 CHAR) NOT NULL ENABLE,
"COL3" VARCHAR2(4 CHAR) NOT NULL ENABLE,
"COL4" DATE NOT NULL ENABLE ) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 0
INITRANS 1
MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE
(
INITIAL 114688
NEXT 131072
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL
DEFAULT FLASH_
CACHE
DEFAULT CELL_FLASH_
CACHE DEFAULT)
TABLESPACE "USERS" ENABLE ROW MOVEMENT
ALTER TABLE "SUSAN"."TEST_STO" MODIFY ("COL4" NOT NULL ENABLE)
ALTER TABLE "SUSAN"."TEST_STO" MODIFY ("COL3" NOT NULL ENABLE)
ALTER TABLE "SUSAN"."TEST_STO" MODIFY ("COL2" NOT NULL ENABLE)
ALTER TABLE "SUSAN"."TEST_STO" MODIFY ("COL1" NOT NULL ENABLE);
When script is run, it fails with "ORA-02143: Invalid STORAGE option"