set time on
set echo on
spool delete_DI_ORG_11113300.log

delete from storetw.STATION_PROJECT where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.LU_INDEXTYPE where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.LU_METRICTYPE where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.FA_STATION where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_PROGRAM where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_SAMPLE_GEAR where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_SAMPLE_PRESRV where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_SAMPLE_PROC where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.WS_PROJECT_STATION_CHAR where ORGANIZATION_ID = '11113300' ;
commit;


delete from storetw.STATION_CHAR where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.WS_STATION_VIEW_VIEW where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.ORG_CHARTYPE where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.STATE_ORG where ORGANIZATION_ID = '11113300' ;
commit;

--delete from storetw.BIN$iSb4R1RrgmTgQ4ZDY5WCZA==$0 where ORGANIZATION_ID = '11113300' ;
--commit;

delete from storetw.FA_HABITAT_RESULT where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.FA_BIO_HABITAT_INDEX where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.WS_STATION_DATA where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.WS_HUC_ORG_CHAR_SUMMARY where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.WS_STATION_SUMMARY where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_ANALYTICAL_PROC where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_CITATION where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_COOP where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_COOP_ADDRESS where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.FA_BIOLOGICAL_RESULT where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.FA_ACTIVITY_GROUP where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.FA_ACTIVITY_METRIC where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.WS_ORG_ACTIVITY where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.WS_ORG_ACTIVITY_PROJECT where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_COOP_EADDRESS where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_LAB where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_LAB_ADDRESS where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_LAB_EADDRESS where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_LAB_SAMPLE_PREP_PROCEDURE where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_ORG_ADDRESS where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.MD_ORG_EADDRESS where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.WS_HUC_ORG_SUMMARY where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.FA_REGULAR_RESULT where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.WS_STATION_VIEW where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.WS_STATION_VIEW_PROD where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.LU_EXTERNAL_REF_SCHEME where ORGANIZATION_ID = '11113300' ;
commit;

delete from storetw.DI_ORG where ORGANIZATION_ID = '11113300' ;
commit;

--41 rows selected.

spool off
