oracle 导出 sequence

select 'create sequence ' || 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 = UPPER('&SEQUENCE_OWNER');

运行输入sequence的所有者,就会得到一些SQL.拿出在PL/SQL执行就行了