Java插入数据时报了ora-01502错误

2017-05-03 18:45:20.830 c.s.d.p.s.b.TgsVehicleToOracleBolt_XZ [ERROR] ORA-01502: 绱㈠?'JCPT_HC3.SYS_C0010810' 骅跨被绱㈠肩

                                                                                                                           邋哄?   瀵绋缍鎊[[?1;2c

                                                                                                                                浜涓

java.sql.BatchUpdateException: ORA-01502: 绱㈠?'JCPT_HC3.SYS_C0010810' 骅跨被绱㈠肩

                                                                                    邋哄?   瀵绋缍?

                                                                                         浜涓

       at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343) ~[stormjar.jar:?]

       at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698) ~[stormjar.jar:?]

       at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:559) ~[stormjar.jar:?]

       at com.supconit.data.process.storm.bolts.TgsVehicleToOracleBolt_XZ.writeToDb(TgsVehicleToOracleBolt_XZ.java:226) [stormjar.jar:?]

       at com.supconit.data.process.storm.bolts.TgsVehicleToOracleBolt_XZ.access$0(TgsVehicleToOracleBolt_XZ.java:155) [stormjar.jar:?]

       at com.supconit.data.process.storm.bolts.TgsVehicleToOracleBolt_XZ$1.run(TgsVehicleToOracleBolt_XZ.java:80) [stormjar.jar:?]

       at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [?:1.7.0_71]

       at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) [?:1.7.0_71]

       at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) [?:1.7.0_71]

       at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.7.0_71]

       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [?:1.7.0_71]

       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [?:1.7.0_71]

       at java.lang.Thread.run(Thread.java:745) [?:1.7.0_71]

解决：

这其实是因为表的索引需要重建，只要将需要插入的目标表的所有索引rebuild即可。

至于为什么会出现这种情况，大概是：

1、一个普通heap表，被truncate了；

2、分区表，truncate一个分区或者多个分区；

3、如果分区表的一个全局索引，当drop掉分区后，最好也重建下索引；

4、大量delete操作后，建议重建下索引；

应该还有其他的场景。