oracle_gg_sequences_manual

During a switchover you might need to drop and re-create sequences. As such, here is a simple script to do so:

Run on OLD primary

select 'drop sequence ibp.'||object_name||'; create sequence ibp.'||object_name||' increment by 1 start with '||ibp.getsequencevalue(object_name)||' MAXVALUE 999999999999999999 MINVALUE 1;'
from dba_objects where owner = 'schema_name' and object_type = 'SEQUENCE';

The output you should run on the NEW primary.

  • oracle_gg_sequences_manual.txt
  • Last modified: 2019/10/18 20:04
  • by 127.0.0.1