问题现象: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batch update; uncategorized SQLException for SQL [insert into HSC_REC_PRODUCT (ENDDATE, IDU, INTIME, PACKAGEID, PRICE, PRODID, PROXYLOG, RECDATE, REGION, STANDARDTARIFF, STARTDATE, SUBSID, TARIFFITEMID, SEQNUM) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [14400]; ORA-14400: 插入的分区关键字未映射到任何分区
business.12-17-11:12-17 11:06:58 - [ZH201212151483940419]----> 不能获取数据库连接,请确认数据库已经启动并连接正常.
查询表的分区:
select * from user_tab_partitions t where t.table_name = 'HSC_REC_PRODUCT';
添加分区:
alter table HSC_REC_PRODUCT add PARTITION HSC_REC_PRODUCT16 values less than(TO_DATE('2013-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'));
alter table HSC_REC_PRODUCT add PARTITION HSC_REC_PRODUCT17 values less than(TO_DATE('2013-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'));
alter table HSC_REC_PRODUCT add PARTITION HSC_REC_PRODUCT18 values less than(TO_DATE('2013-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'));
alter table HSC_REC_PRODUCT add PARTITION HSC_REC_PRODUCT19 values less than(TO_DATE('2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'));
alter table HSC_REC_PRODUCT add PARTITION HSC_REC_PRODUCT20 values less than(TO_DATE('2013-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'));