Differences

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

--- oracle_golden_gate_switchover [2018/10/15 10:50] – external edit 127.0.0.1
+++ 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 286: / Line 286: @@
 dbms_xmlgen.getxml('select count(*) c from &&owner .'||table_name)),'/ROWSET/ROW/C')) count
 FROM dba_tables where owner = '&owner'
-order by table_name,count asc;
+order by count asc;
 </sxh>
@@ 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!!!