Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

List partitioned table with ORA-14400

USER101May 16 2022 — edited May 16 2022

Hello all,

Please can someone let me know what is going on here ? I see the LIST partitioned table throwing this error. I see the value being inserted is a valid integer.

	SQL> select partition_name,high_value from dba_tab_partitions where table_name='TCDU';


PARTITION_NAME         HIGH_VALUE
------------------------------ ------------------------------
BLOCK0             0
BLOCK1             1
BLOCK2             2
BLOCK3             3
BLOCK4             4
BLOCK5             5

6 rows selected.

SQL> SQL> insert into iomss01.TCDU(TCDU_INST_ID) values (1);
insert into iomss01.TCDU(TCDU_INST_ID) values (1)
          *
ERROR at line 1:
ORA-14400: inserted partition key does not map to any partition

Thanks in advance

Comments

Post Details

Added on May 16 2022
6 comments
116 views
1 mention