set time on
set echo on
spool rename_DI_ORG_11113300.log

update storetw.STATION_PROJECT set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.LU_INDEXTYPE set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.LU_METRICTYPE set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.FA_STATION set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.MD_PROGRAM set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;

commit;

update storetw.MD_SAMPLE_GEAR set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.MD_SAMPLE_PRESRV set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.MD_SAMPLE_PROC set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.WS_PROJECT_STATION_CHAR set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;



update storetw.STATION_CHAR set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.WS_STATION_VIEW_VIEW set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.ORG_CHARTYPE set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;


update storetw.STATE_ORG set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

--update storetw.BIN$iSb4R1RrgmTgQ4ZDY5WCZA==$0 set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
--commit;

update storetw.FA_HABITAT_RESULT set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.FA_BIO_HABITAT_INDEX set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.WS_STATION_DATA set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;

commit;

update storetw.WS_HUC_ORG_CHAR_SUMMARY set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.WS_STATION_SUMMARY set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.MD_ANALYTICAL_PROC set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.MD_CITATION set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;


update storetw.MD_COOP set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.MD_COOP_ADDRESS set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.FA_BIOLOGICAL_RESULT set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.FA_ACTIVITY_GROUP set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;


update storetw.FA_ACTIVITY_METRIC set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.WS_ORG_ACTIVITY set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.WS_ORG_ACTIVITY_PROJECT set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.MD_COOP_EADDRESS set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.MD_LAB set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;

commit;

update storetw.MD_LAB_ADDRESS set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.MD_LAB_EADDRESS set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.MD_LAB_SAMPLE_PREP_PROCEDURE set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.MD_ORG_ADDRESS set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;


update storetw.MD_ORG_EADDRESS set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.WS_HUC_ORG_SUMMARY set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.FA_REGULAR_RESULT set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.WS_STATION_VIEW set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;


update storetw.WS_STATION_VIEW_PROD set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

update storetw.LU_EXTERNAL_REF_SCHEME set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;


update storetw.DI_ORG set ORGANIZATION_ID = '11113300' where ORGANIZATION_ID = '11113300_WQX' ;
commit;

--41 rows selected.

spool off
