Toad World® Forums

Incorrect syntax when generating script for partitioned table with local index

Oracle 11.2

VALUES clause in local index generated code is incorrect in SUBPARTITION clause - parser flags the error when I paste script into Editor - see VALUES(1) below

CREATE INDEX MAIN_ORDER_IDX1 ON MAIN_ORDER
(FUNCTIONAL_GROUP_CODE, CREATION_DTTM, SOURCE_TRADING_ACCT_ID, SYMBOL, AS_SENT_CLIENT_ORDER_ID)
TABLESPACE MAIN_ORDER_INDEX_20161205
LOGGING
LOCAL (
PARTITION MO_P_W20151228
LOGGING
NOCOMPRESS
TABLESPACE MAIN_ORDER_INDEX_20151228
(SUBPARTITION MO_P_W20151228_OMS VALUES (1)
TABLESPACE MAIN_ORDER_INDEX_20151228,

thanks. fixed for next beta.