ORA-14400: inserted partition key does not map to any partition



INSERT INTO COMPLAINT (MSISDN) VALUES ('9000000');
INSERT INTO COMPLAINT (MSISDN) VALUES ('9000000')
            *
ERROR at line 1:
ORA-14400: inserted partition key does not map to any partition


Check 

DBA_PART_TABLES
DBA_PART_KEY_COLUMNS

Include all those columns that are reported in DBA_PART_KEY_COLULMNS in the insert statement.

Here it is REQ_DATE

INSERT INTO COMPLAINT (MSISDN,REQ_DATE) VALUES ('9000000','09-APR-09');

1 row created.

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post