导出全部Sequence

select 'create sequence '||sequence_name||
' minvalue '||min_value||
' maxvalue '||max_value||
' start with '||last_number||
' increment by '||increment_by||
(case when cache_size=0 then ' nocache' else ' cache '||cache_size end) ||';'
from dba_sequences where sequence_owner='FWD'


create sequence SEQ_SALESTRACKCOMPARE_INDEX minvalue 1 maxvalue 99999999999999999999 start with 41 increment by 1 cache 20;
create sequence SEQ_SALESTRACK_INDEX minvalue 1 maxvalue 99999999999999999999999 start with 551382 increment by 1 cache 20;
create sequence FS_APPMENUS_INDEX minvalue 1 maxvalue 9999999999999999 start with 1 increment by 1 cache 20;
create sequence FS_APPROLES_INDEX minvalue 1 maxvalue 999999999999999 start with 41 increment by 1 cache 20;
create sequence FS_ROLEMENUS_INDEX minvalue 1 maxvalue 9999999999999999 start with 300 increment by 1 cache 20;
create sequence FS_USER_INDEX minvalue 1 maxvalue 999999999999999 start with 1020 increment by 1 cache 20;
create sequence QUEST_SOO_AT_SEQUENCE minvalue 1 maxvalue 999999999999999999999999999 start with 1 increment by 1 cache 20;
create sequence SEQ_OPERLOG_AUTOID minvalue 1 maxvalue 999999999999999999 start with 335461 increment by 1 cache 20;
create sequence SEQ_DTIIMPORTLOG_AUTOID minvalue 1 maxvalue 999999999999999999999999 start with 11563 increment by 1 cache 20;