Error Using "subpartition-extended Table Name" Syntax In INSERT INTO Statement. Receive ORA-14173: illegal subpartition-extended table name syntax (Doc ID 1481564.1)

Last updated on OCTOBER 14, 2019

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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.