declare dummy number; begin for sq in ( select sequence_owner||'.'||sequence_name nm from dba_sequences where sequence_owner in ( 'CLIENTDBO','DEALERTOOLS_DBO','GAINDBO','IT_JOB_LOG','MXDBO','MYBROKERDBO', 'NEWTOPSDBO','ODFSDBO','ODL_DBADMIN_DBO','ODL_DBSERVICES_DBO','ODL_USERAPPS_DBO', 'PRODUCTDBO','RECONCILIATIONSDBO','SETTLEMENTSDBO','USER_ADMIN_SYS','WEB') ) loop dbms_output.put_line(sq.nm); for i in 1..10000 loop execute immediate 'select '||sq.nm||'.nextval from dual' into dummy; end loop; end loop; end; |
Friday, 5 February 2010
Oracle : Rolling sequences forward
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment