java.sql.SQLSyntaxErrorException: ORA-02289:序列不存在

关注

原创最新推荐文章于 2026-05-13 10:17:33 发布 9.6k 阅读 AI 写同款· GEO 优化 ›

【SpringBatch】spring batch-批量-Oracle环境下的初始化建表语句：java.sql.SQLSyntaxErrorException: ORA-02289 一、问题最近在自己搭建spring batch的框架，一步一步趟坑中； java.sql.SQLSyntaxErrorException: ORA-02289 二、解决通过Debug发现，就是在这一句代码执行时报错的： JobExecution execution = this.jobLauncher.run(job, nextParameters); 但是，我们找到这个run()方法，发... 阅读详情

今天在迁oracle移数据库到另一个机子时出现这个错误，之前也迁移过一次序列都导出了，可这次没有导出，网上搜了些资料发现可以用下面的方法单独到处序列，在Oracle的sql窗口中输入以下语句：

SELECT ' CREATE SEQUENCE '||SEQUENCE_NAME|| ' INCREMENT BY '||

INCREMENT_BY ||' START WITH '||LAST_NUMBER||' MAXVALUE '||
MAX_VALUE ||' CACHE '||CACHE_SIZE||' ORDER NOCYCLE ;'

FROM user_SEQUENCES;

执行后出现以下语句：（从表格中复制出的）

CREATE SEQUENCE SEQ_TBL_JDC INCREMENT BY 1 START WITH 21 MAXVALUE 99999999 CACHE 20 ORDER NOCYCLE ;
CREATE SEQUENCE SEQ_TBL_JS INCREMENT BY 1 START WITH 101 MAXVALUE 10000000 CACHE 20 ORDER NOCYCLE ;
CREATE SEQUENCE SEQ_TBL_JS_MK INCREMENT BY 1 START WITH 161 MAXVALUE 10000000 CACHE 20 ORDER NOCYCLE ;
CREATE SEQUENCE SEQ_TBL_WXYH_QY INCREMENT BY 1 START WITH 401 MAXVALUE 99999999 CACHE 20 ORDER NOCYCLE ;
CREATE SEQUENCE SEQ_TBL_XFXX INCREMENT BY 1 START WITH 301 MAXVALUE 99999999 CACHE 20 ORDER NOCYCLE ;
CREATE SEQUENCE SEQ_TBL_YGZWXYH INCREMENT BY 1 START WITH 481 MAXVALUE 99999999 CACHE 20 ORDER NOCYCLE ;
CREATE SEQUENCE SEQ_TBL_YHXX INCREMENT BY 1 START WITH 261 MAXVALUE 10000000 CACHE 20 ORDER NOCYCLE ;
CREATE SEQUENCE SEQ_TBL_YH_JS INCREMENT BY 1 START WITH 261 MAXVALUE 10000000 CACHE 20 ORDER NOCYCLE ;
CREATE SEQUENCE SEQ_WCTTBLPZLB INCREMENT BY 1 START WITH 15 MAXVALUE 99999999 CACHE 10 ORDER NOCYCLE ;
CREATE SEQUENCE SEQ_WCTTBLSWSXX INCREMENT BY 1 START WITH 186 MAXVALUE 99999999 CACHE 10 ORDER NOCYCLE ;
CREATE SEQUENCE WCTTBLGFBMXX_SEQ INCREMENT BY 1 START WITH 441 MAXVALUE 9999999999999999999999999999 CACHE 20 ORDER NOCYCLE ;
CREATE SEQUENCE WCTTBLSPBM_SEQ INCREMENT BY 1 START WITH 981 MAXVALUE 9999999999999999999999999999 CACHE 20 ORDER NOCYCLE ;
CREATE SEQUENCE WCTTBLZZSFPMX_SEQ INCREMENT BY 1 START WITH 1621 MAXVALUE 9999999999999999999999999999 CACHE 20 ORDER NOCYCLE ;
CREATE SEQUENCE WCTTBLZZSFPZB_SEQ INCREMENT BY 1 START WITH 981 MAXVALUE 9999999999999999999999999999 CACHE 20 ORDER NOCYCLE ;

然后在新机子上复制运行即可。

收录于