武安建设局网站十大引擎网址
今天在遷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 ;
然後在新機子上複製運行即可。