Last updated on FEBRUARY 02, 2017

Applies to:

Symptoms

The following error is received on the INSERT INTO table subpartition with SUBPARTITION FOR syntax (also occurs with Partition syntax):

ORA-14173: illegal subpartition-extended table name syntax

when trying to use INSERT.

SQL> INSERT /*+APPEND */ INTO PART_TEST_TBL SUBPARTITION FOR (10,'BLUE')
  (data_origin_id,table_name  ,dur_uk ,dur_uk_id)
  SELECT ptt.data_origin_id   ,ptt.table_name  ,ptt.dur_uk || '!' dur_uk ,ptt.dur_uk_id + 1000 dur_uk_id
 FROM PART_TEST_TBL ptt
WHERE ptt.table_name = 'BLUE'  AND ptt.data_origin_id = 10;

INSERT /*+APPEND */ INTO PART_TEST_TBL SUBPARTITION FOR (10,'BLUE')
                                                       *
ERROR at line 1:
ORA-14173: illegal subpartition-extended table name syntax

Cause