классика
(a la softbuilder :-)

CREATE SEQUENCE ZUE_SEC_TEST
INCREMENT BY 1
START WITH 1
MINVALUE 1
MAXVALUE 700
/
CREATE SEQUENCE ZUE_SEC_TEST1
INCREMENT BY 1
START WITH 1
MINVALUE 1
MAXVALUE 700
/

SQL> select 'ALTER SEQUENCE '||sequence_name||' MAXVALUE 1500;' as commands
2 from all_sequences
3 where sequence_owner='ZUE'
4 ;

COMMANDS
------------------------------------------------------------
ALTER SEQUENCE ZUE_SEC_TEST MAXVALUE 1500;
ALTER SEQUENCE ZUE_SEC_TEST1 MAXVALUE 1500;

SQL> spool off
И запустить полученный скрипт.