MAXSIZE parameter is missing from scripts generate when the extracting DDL for an index .
Original:
CREATE INDEX SAMPLE_PERSON_INFO ON PERSONAL_INFO
(
FIRST_NAME
)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE
(
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
MAXSIZE UNLIMITED
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
TABLESPACE "INDX" ;
Incorrect Generation:
CREATE INDEX SAMPLE_PERSON_INFO ON PERSONAL_INFO
(
FIRST_NAME
)
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
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad for Oracle.
Applies to various versions of Toad.
