oracle 的exp命令没有导出sequence的选项,在网上找了个生成重建语句的查询,记录以备不测
select 'create sequence SYSTEM.'|| SEQUENCE_NAME || ' minvalue '||MIN_VALUE||' maxvalue '||MAX_VALUE||'
start with '||LAST_NUMBER||' increment by '||INCREMENT_BY||' cache '||CACHE_SIZE||' ;'
from dba_sequences where SEQUENCE_OWNER='SYSTEM'
create sequence SYSTEM.SEQ0001T minvalue 1 maxvalue 9999999999999999999 start with 1 increment by 1 cache 20 ;