Oracle导出数据库中全部sequence

Oracle导出数据库中所有sequence

select 'create sequence &your_schema_name.'|| 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('&your_schema_name');