Show pageOld revisionsBacklinksODT exportBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. =====Overview===== 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=== <sxh bash> 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'; </sxh> The output you should run on the NEW primary. oracle_gg_sequences_manual.txt Last modified: 2019/10/18 20:04by 127.0.0.1