Aumentar todas las secuencias de un esquema en una base de datos Oracle
Sharing knowledge!
DATE_FORMAT_LC2
Por ejemplo, para aumentar todas las secuencias del esquema SCHEMA1 en 100000:
select 'alter sequence '||t.sequence_name||' increment by 100000;' from all_sequences t where sequence_owner='SCHEMA1 ';

select 'select '||t.sequence_name||'.nextval from dual;' from all_sequences t where sequence_owner='SCHEMA1 ';

select 'alter sequence '||t.sequence_name||' increment by 1;' from all_sequences t where sequence_owner='SCHEMA1 ';
LAST_UPDATED2
 

FORM_HEADER


FORM_CAPTCHA
FORM_CAPTCHA_REFRESH