Oracle Export SEQUENCE source

select

'DROP SEQUENCE ' || seq.SEQUENCE_OWNER || '.' || seq.SEQUENCE_NAME || ';'  DSQL,

'CREATE SEQUENCE ' || seq.SEQUENCE_OWNER || '.' || seq.SEQUENCE_NAME 

|| ' INCREMENT BY 1 ' 

|| ' START WITH ' || seq.LAST_NUMBER 

|| ' MINVALUE ' || seq.MIN_VALUE

|| ' MAXVALUE ' || seq.MAX_VALUE 

|| '  ' || CASE seq.CYCLE_FLAG WHEN 'Y' THEN 'CYCLE' ELSE 'NOCYCLE' END

|| '  ' || CASE seq.ORDER_FLAG WHEN 'Y' THEN 'ORDER' ELSE 'NOORDER' END

|| '  ' || CASE seq.CACHE_SIZE WHEN 0 THEN 'NOCACHE' ELSE 'CACHE ' || seq.CACHE_SIZE  END || ' ; '  CSQL, 

 seq.* 

from ALL_SEQUENCES seq

where  SEQUENCE_OWNER IN('SYS', 'SYSTEM')

order by SEQUENCE_OWNER