CREATE SEQUENCE

Desde un esquema crear todas las secuencias antes de borrarlas.

Select 'create sequence <schema>."'||SEQUENCE_NAME||'" START WITH 1 '||' MAXVALUE '||MAX_VALUE||' MINVALUE '||MIN_VALUE||' '||DECODE(CYCLE_FLAG,'N','NOCYCLE')||' CACHE '||CACHE_SIZE||' '||DECODE(ORDER_FLAG,'N','NOORDER')||' '||DECODE(KEEP_VALUE,'N','NOKEEP')||' GLOBAL; '
from dba_sequences where SEQUENCE_OWNER ='schema';