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:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |