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.