日期:2014-05-16  浏览次数:20531 次

批量修改SEQUENCE,序列同时增加10000

select 'alter sequence ' || t1.sequence_name ||
?????? ' increment by 10000 nocache;'
? from user_sequences t1
union all
select 'select ' || t2.sequence_name || '.nextval from dual;'
? from user_sequences t2
union all
select ' alter sequence ' || t3.sequence_name ||
?????? ' increment by 1 CACHE 20;'
? from user_sequences t3;