Differences

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

--- oracle_golden_gate_switchover [2019/03/20 14:59] – [Count the rows of all tables within one schema] andonovj
+++ oracle_golden_gate_switchover [2023/11/27 13:17] (current) – [Sequences] andonovj
@@ Line 162: / Line 162: @@
 =====Start Extract + Data pump on Standby (New Primary)=====
 <sxh bash>
-GGSCI (Naos.izb.local) 4> add extract EBKPEXT1,TRANLOG,BEGIN NOW
+GGSCI (Naos.izb.local) 4> add extract EBKEXT1,TRANLOG,BEGIN NOW
 EXTRACT added.
-GGSCI (Naos.izb.local) 1> add EXTTRAIL ./dirdat/lt, EXTRACT EBKPEXT1
+GGSCI (Naos.izb.local) 1> add EXTTRAIL ./dirdat/lt, EXTRACT EBKEXT1
 EXTTRAIL added.
@@ 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!!!