oracle_gg_sequences_manual

Differences

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

Link to this comparison view

Next revision		 Previous revision
oracle_gg_sequences_manual [2019/08/02 09:04] – created andonovjoracle_gg_sequences_manual [2019/10/18 20:04] (current) – external edit 127.0.0.1
Line 4: Line 4:
 ===Run on OLD primary=== ===Run on OLD primary===
 <sxh bash> <sxh bash>
-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 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'; from dba_objects where owner = 'schema_name' and object_type = 'SEQUENCE';
 </sxh> </sxh>
  • oracle_gg_sequences_manual.1564736699.txt.gz
  • Last modified: 2019/10/18 20:04
  • (external edit)