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

原因：插入值大于已存在分区的最大值，超出范围

1.查看该表有多少个partition

select * from user_tab_partitions where table_name='TNK_MR_BA_CELL';

2.加一个最大值得分区

ALTER TABLE TNK_MR_BA_CELL ADD PARTITION TNK_MR_BA_CELL11 VALUES LESS THAN (MAXVALUE) tablespace=xxx;

3.再导入数据

sqlldr user/optr@db control=./tnk_mr_ba_cell.ctl data=tnk_mr_ba_cell.unl

ITPub博客

ORA-14400