Differences

This shows you the differences between two versions of the page.

--- oracle_golden_gate_switchover [2019/07/03 22:01] – [Start Extract + Data pump on Standby (New Primary)] andonovj
+++ oracle_golden_gate_switchover [2023/11/27 13:17] (current) – [Sequences] andonovj
@@ Line 294: / Line 294: @@
 <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;'
+select 'drop sequence '||sequence_owner||'.'||sequence_name||'; \n
-from dba_objects where owner = 'IBP' and object_type = 'SEQUENCE';
+create sequence '||sequence_owner||'.'||sequence_name||' increment by 1 start with '||(last_number)||' MAXVALUE 999999999999999999 MINVALUE 1;'
+from dba_sequences where sequence_owner in ('OWNER_1','OWNER_2');
 </sxh>
 !!!Happy End!!!