ORA-14024: number of partitions of LOCAL index must equal that of the underlying table

建立PARTITION IDXEX時出現下列錯誤訊息，代表沒有對應的PARTITION存在
CREATE IDXEX MY_PTIDX_TX_DTL ON MY_PTTAB_TX_DTL(DATE_TIME)
                                *
 ERROR 在行 1:
ORA-14024: number of partitions of LOCAL IDXex must equal that of the underlying table

以此例來看，即為紅色字的PARTITION不存在，可手動建立PARTITION或先移除此兩行先建立INDEX。

CREATE IDXEX MY_PTIDX_TX_DTL ON MY_PTTAB_TX_DTL(DATE_TIME)
LOCAL
  (
  PARTITION PT_200809 TABLESPACE TS_TX_DTL_09_IDX,
  PARTITION PT_200810 TABLESPACE TS_TX_DTL_10_IDX,
  PARTITION PT_200811 TABLESPACE TS_TX_DTL_11_IDX,
  PARTITION PT_200812 TABLESPACE TS_TX_DTL_12_IDX,
  PARTITION PT_200901 TABLESPACE TS_TX_DTL_01_IDX,
  PARTITION PT_200902 TABLESPACE TS_TX_DTL_02_IDX,
  PARTITION PT_200903 TABLESPACE TS_TX_DTL_03_IDX,
  PARTITION PT_200904 TABLESPACE TS_TX_DTL_04_IDX,
  PARTITION PT_200905 TABLESPACE TS_TX_DTL_05_IDX
  )
/