set echo off
Rem  Copyright (c) 1998 by U.S. Environmental Protection Agency 
Rem    NAME
Rem      del_demo.sql
Rem    DESCRIPTION
Rem      Script (del_demo.sql) Removes ALL DEMOTEST`s Rows from Schema STORET1
Rem    RETURNS
Rem    NOTES
Rem    MODIFIED   (MM/DD/YY)
Rem     kchristian   02/13/2003 -  Creation 
rem 
rem $Header: analyze.sql,v 1.0 1998/07/01 12:00:00 KCHRISTIAN Exp $ 
rem 
--connect storet1/sto2et1@storet
set termout on
set echo on
--  
-- SQL Plus Environment Variables
set echo off
set verify off
set feedback off
set termout on
set time off
set timing off
set heading off
set linesize 300
set pagesize 0

show user

PROMPT Please Wait... Removing DEMOTEST's Rows from schema owner STORET1
set feedback ON
set time ON
set termout OFF
spool c:\del_DEMOTEST.log

PROMPT  Removing DEMOTEST's Rows from table TSMADDR ,  Please Wait...
 Delete From STORET1.TSMADDR WHERE TSMADDR_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMALP ,  Please Wait...
 Delete From STORET1.TSMALP WHERE TSMALP_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMCHKPT ,  Please Wait...
 Delete From STORET1.TSMCHKPT WHERE LAST_PROCESSED_ORG1='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMCPORG ,  Please Wait...
 Delete From STORET1.TSMCPORG WHERE TSMCPORG_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMCSNG ,  Please Wait...
 Delete From STORET1.TSMCSNG WHERE TSMINTVL_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMEADDR ,  Please Wait...
 Delete From STORET1.TSMEADDR WHERE TSMEADDR_ORG_ID='DEMOTEST'  ;
 COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSMEISN ,  Please Wait...
 Delete From STORET1.TSMEISN WHERE TSMEISN_ORG_ID='DEMOTEST'  ;
 COMMIT;
-- PROMPT  Removing ZZZZZZZZ's Rows from table TSMEISN ,  Please Wait...
--  Delete From STORET1.TSMEISN WHERE TSMEISN_ORG_ID='ZZZZZZZZ' ;
--  COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSMERS ,  Please Wait...
 Delete From STORET1.TSMERS WHERE TSMERS_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMESTLC ,  Please Wait...
 Delete From STORET1.TSMESTLC WHERE TSMALP_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMFCLTY ,  Please Wait...
 Delete From STORET1.TSMFCLTY WHERE TSMSTATN_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMFILL ,  Please Wait...
 Delete From STORET1.TSMFILL WHERE TSMINTVL_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMFSA ,  Please Wait...
 Delete From STORET1.TSMFSA WHERE TSMSTATN_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMGLL ,  Please Wait...
 Delete From STORET1.TSMGLL WHERE TSMALP_ORG_ID='DEMOTEST'  ;
 COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSMGNTXT ,  Please Wait...
 Delete From STORET1.TSMGNTXT WHERE TSMGNTXT_ORG_ID='DEMOTEST'  ;
 COMMIT;
-- PROMPT  Removing ZZZZZZZZ's Rows from table TSMGNTXT ,  Please Wait...
--  Delete From STORET1.TSMGNTXT WHERE TSMGNTXT_ORG_ID='ZZZZZZZZ' ;
--  COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSMHOLE ,  Please Wait...
 Delete From STORET1.TSMHOLE WHERE TSMINTVL_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMIGUA ,  Please Wait...
 Delete From STORET1.TSMIGUA WHERE TSMIGUA_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMINTVL ,  Please Wait...
 Delete From STORET1.TSMINTVL WHERE TSMINTVL_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMLOG ,  Please Wait...
 Delete From STORET1.TSMLOG WHERE TSMLOG_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMOCNLC ,  Please Wait...
 Delete From STORET1.TSMOCNLC WHERE TSMALP_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMOPNG ,  Please Wait...
 Delete From STORET1.TSMOPNG WHERE TSMINTVL_ORG_ID='DEMOTEST'  ;
 COMMIT;

-- PROMPT  Removing DEMOTEST's Rows from table TSMORGAN ,  Please Wait...
--  Delete From STORET1.TSMORGAN WHERE ORG_ID='ZZZZZZZZ' ;
--  COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSMPCOA ,  Please Wait...
 Delete From STORET1.TSMPCOA WHERE TSMPROJ_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMPERSN ,  Please Wait...
 Delete From STORET1.TSMPERSN WHERE TSMPERSN_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMPIPE ,  Please Wait...
 Delete From STORET1.TSMPIPE WHERE TSMPIPE_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMPMGRD ,  Please Wait...
 Delete From STORET1.TSMPMGRD WHERE TSMSTATN_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMPMTCT ,  Please Wait...
 Delete From STORET1.TSMPMTCT WHERE TSMSTATN_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMPPA ,  Please Wait...
 Delete From STORET1.TSMPPA WHERE TSMPROJ_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMPPRA ,  Please Wait...
 Delete From STORET1.TSMPPRA WHERE TSMPROJ_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMPRA ,  Please Wait...
 Delete From STORET1.TSMPRA WHERE TSMPERSN_ORG_ID='DEMOTEST'  ;
 COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSMPROGM ,  Please Wait...
 Delete From STORET1.TSMPROGM WHERE TSMPROGM_ORG_ID='DEMOTEST'  ;
 COMMIT;
-- PROMPT  Removing ZZZZZZZZ's Rows from table TSMPROGM ,  Please Wait...
--  Delete From STORET1.TSMPROGM WHERE TSMPROGM_ORG_ID='ZZZZZZZZ' ;                              
--  COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSMPROJ ,  Please Wait...
 Delete From STORET1.TSMPROJ WHERE TSMPROJ_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMPRPRA ,  Please Wait...
 Delete From STORET1.TSMPRPRA WHERE TSMPROJ_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMPSA ,  Please Wait...
 Delete From STORET1.TSMPSA WHERE TSMSTATN_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMPSRA ,  Please Wait...
 Delete From STORET1.TSMPSRA WHERE TSMSTATN_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMPUMP ,  Please Wait...
 Delete From STORET1.TSMPUMP WHERE TSMPUMP_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMRFLBL ,  Please Wait...
 Delete From STORET1.TSMRFLBL WHERE TSMSTATN_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMSCTS ,  Please Wait...
 Delete From STORET1.TSMSCTS WHERE TSMSOI_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMSOI ,  Please Wait...
 Delete From STORET1.TSMSOI WHERE TSMSOI_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMSPRNG ,  Please Wait...
 Delete From STORET1.TSMSPRNG WHERE TSMSTATN_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMSTATN ,  Please Wait...
 Delete From STORET1.TSMSTATN WHERE TSMSTATN_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMTBINF ,  Please Wait...
 Delete From STORET1.TSMTBINF WHERE ALTERNATE_ORG_ID='DEMOTEST'  ;
 COMMIT;
/*  commented out to keep the tsmuoa data.
-- Delete From STORET1.TSMUOA WHERE TSMORGAN_IS_NUMBER=1 ;
PROMPT  Removing DEMOTEST's Rows from table TSMUOA ,  Please Wait...
 Delete From STORET1.TSMUOA WHERE TSMORGAN_IS_NUMBER=
                     (select TSMORGAN_IS_NUMBER From STORET1.TSmorgan where org_id='DEMOTEST') ;
*/
 COMMIT;
--commented out to keep the tsmuser data.
-- Delete From STORET1.TSMUSER WHERE TSMORGAN_IS_NUMBER=1 ;
PROMPT  Removing DEMOTEST's Rows from table TSMUSER ,  Please Wait...
-- Delete From STORET1.TSMUSER ;
 COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSMVSC ,  Please Wait...
 Delete From STORET1.TSMVSC WHERE TSMVSC_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMWELL ,  Please Wait...
 Delete From STORET1.TSMWELL WHERE TSMWELL_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMWLE ,  Please Wait...
 Delete From STORET1.TSMWLE WHERE TSMWELL_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRAAL ,  Please Wait...
 Delete From STORET1.TSRAAL WHERE TSMALP_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRADL ,  Please Wait...
 Delete From STORET1.TSRADL WHERE TSRADL_ORG_ID='DEMOTEST'  ;
 COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSRANLPR ,  Please Wait...
 Delete From STORET1.TSRANLPR WHERE TSRANLPR_ORG_ID='DEMOTEST'  ;
 COMMIT;
-- PROMPT  Removing ZZZZZZZZ's Rows from table TSRANLPR ,  Please Wait...
--  Delete From STORET1.TSRANLPR WHERE TSRANLPR_ORG_ID='ZZZZZZZZ' ;
--  COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSRBRG ,  Please Wait...
 Delete From STORET1.TSRBRG WHERE TSRBRG_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRBRGI ,  Please Wait...
 Delete From STORET1.TSRBRGI WHERE TSRBRGI_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRCCGA ,  Please Wait...
 Delete From STORET1.TSRCCGA WHERE TSRCCGA_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRCHDEF ,  Please Wait...
 Delete From STORET1.TSRCHDEF WHERE TSRCHDEF_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRCHGRP ,  Please Wait...
 Delete From STORET1.TSRCHGRP WHERE TSRCHGRP_ORG_ID='DEMOTEST'  ;
 COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSRCITN ,  Please Wait...
 Delete From STORET1.TSRCITN WHERE TSRCITN_ORG_ID='DEMOTEST'  ;
 COMMIT;
-- PROMPT  Removing ZZZZZZZZ's Rows from table TSRCITN ,  Please Wait...
--  Delete From STORET1.TSRCITN WHERE TSRCITN_ORG_ID='ZZZZZZZZ' ;
--  COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSRCLDES ,  Please Wait...
 Delete From STORET1.TSRCLDES WHERE TSRRSULT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRCPA ,  Please Wait...
 Delete From STORET1.TSRCPA WHERE TSMPROJ_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRDQL ,  Please Wait...
 Delete From STORET1.TSRDQL WHERE TSRRSULT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSREOD ,  Please Wait...
 Delete From STORET1.TSREOD WHERE TSRFDACT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRFAFSA ,  Please Wait...
 Delete From STORET1.TSRFAFSA WHERE TSRFDACT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRFAPEA ,  Please Wait...
 Delete From STORET1.TSRFAPEA WHERE TSRFDACT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRFAPRA ,  Please Wait...
 Delete From STORET1.TSRFAPRA WHERE TSRFDACT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRFAQSA ,  Please Wait...
 Delete From STORET1.TSRFAQSA WHERE TSRFDACT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRFDACT ,  Please Wait...
 Delete From STORET1.TSRFDACT WHERE TSRFDACT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRFDSET ,  Please Wait...
 Delete From STORET1.TSRFDSET WHERE TSRFDSET_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRFLDPR ,  Please Wait...
 Delete From STORET1.TSRFLDPR WHERE TSRFLDPR_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRFQS ,  Please Wait...
 Delete From STORET1.TSRFQS WHERE TSRFQS_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRFQSDP ,  Please Wait...
 Delete From STORET1.TSRFQSDP WHERE TSRFQSDP_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRFQSPA ,  Please Wait...
 Delete From STORET1.TSRFQSPA WHERE TSRFQS_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRGRCFG ,  Please Wait...
 Delete From STORET1.TSRGRCFG WHERE TSRGRCFG_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRHCSC ,  Please Wait...
 Delete From STORET1.TSRHCSC WHERE TSRHCSC_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRLAB ,  Please Wait...
 Delete From STORET1.TSRLAB WHERE TSRLAB_ORG_ID='DEMOTEST'  ;
 COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSRLSPP ,  Please Wait...
 Delete From STORET1.TSRLSPP WHERE TSRLSPP_ORG_ID='DEMOTEST'  ;
 COMMIT;
-- PROMPT  Removing ZZZZZZZZ's Rows from table TSRLSPP ,  Please Wait...
-- Delete From STORET1.TSRLSPP WHERE TSRLSPP_ORG_ID='ZZZZZZZZ' ;
-- COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSROAPA ,  Please Wait...
 Delete From STORET1.TSROAPA WHERE TSMORGAN_IS_NUMBER=1;
 Delete From STORET1.TSROAPA WHERE TSMORGAN_IS_NUMBER=
                     (select TSMORGAN_IS_NUMBER From STORET1.TSmorgan where org_id='DEMOTEST') ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSROAPCA ,  Please Wait...
 Delete From STORET1.TSROAPCA WHERE TSMORGAN_IS_NUMBER=1;
 Delete From STORET1.TSROAPCA WHERE TSMORGAN_IS_NUMBER=
                     (select TSMORGAN_IS_NUMBER From STORET1.TSmorgan where org_id='DEMOTEST') ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSROLSPA ,  Please Wait...
 Delete From STORET1.TSROLSPA WHERE TSMORGAN_IS_NUMBER=1;
 Delete From STORET1.TSROLSPA WHERE TSMORGAN_IS_NUMBER=
                     (select TSMORGAN_IS_NUMBER From STORET1.TSmorgan where org_id='DEMOTEST') ;
 COMMIT;

PROMPT  Removing DEMOTEST's Rows from table TSROPPRD ,  Please Wait...
 Delete From STORET1.TSROPPRD WHERE TSROPPRD_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRPOPA ,  Please Wait...
 Delete From STORET1.TSRPOPA WHERE TSROPPRD_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRRCI ,  Please Wait...
 Delete From STORET1.TSRRCI WHERE TSRRSULT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRRLRA ,  Please Wait...
 Delete From STORET1.TSRRLRA WHERE TSRRSULT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRRQCAF ,  Please Wait...
 Delete From STORET1.TSRRQCAF WHERE TSRRQCAF_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRRSULT ,  Please Wait...
 Delete From STORET1.TSRRSULT WHERE TSRRSULT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRSDP ,  Please Wait...
 Delete From STORET1.TSRSDP WHERE TSRSDP_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRSMPLE ,  Please Wait...
 Delete From STORET1.TSRSMPLE WHERE TSRFDACT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRSTVST ,  Please Wait...
 Delete From STORET1.TSRSTVST WHERE TSRSTVST_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRTNOD ,  Please Wait...
 Delete From STORET1.TSRTNOD WHERE TSRFDACT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRTOD ,  Please Wait...
 Delete From STORET1.TSRTOD WHERE TSRFDACT_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRTPA ,  Please Wait...
 Delete From STORET1.TSRTPA WHERE TSRTRIP_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRTRIP ,  Please Wait...
 Delete From STORET1.TSRTRIP WHERE TSRTRIP_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRTSA ,  Please Wait...
 Delete From STORET1.TSRTSA WHERE TSRTRIP_ORG_ID='DEMOTEST'  ;
 COMMIT;

-- NEW STORET v2.0 Tables
-- NEW STORET v2.0 Tables
PROMPT  Removing DEMOTEST's Rows from table TSMBLOB ,  Please Wait...
 Delete From STORET1.TSMBLOB WHERE TSMBLOB_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMFNA ,  Please Wait...
 Delete From STORET1.TSMFNA WHERE TSMSTATN_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSMPSW ,  Please Wait...
 Delete From STORET1.TSMPSW WHERE TSMSTATN_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRFACOA ,  Please Wait...
 Delete From STORET1.TSRFACOA WHERE TSMCPORG_ORG_ID='DEMOTEST'  ;
 COMMIT;
PROMPT  Removing DEMOTEST's Rows from table TSRDLIN ,  Please Wait...
 Delete From STORET1.TSRDLIN WHERE TSRDLIN_ORG_ID='DEMOTEST'  ;
 COMMIT;

-- OLD Table no longer exists in STORET v2.0
--PROMPT  -- OLD Table no longer exists in STORET v2.0
--PROMPT  Removing DEMOTEST's Rows from table TSMAMDA ,  Please Wait...
-- Delete From STORET1.TSMAMDA WHERE TSMMAD_ORG_ID='DEMOTEST'  ;
-- COMMIT;
-- OLD Table no longer exists in STORET v2.0
-- OLD Table no longer exists in STORET v2.0

PROMPT  Removing DEMOTEST's Rows from table TSMORGAN ,  Please Wait...
 Delete From STORET1.TSMORGAN WHERE ORG_ID='DEMOTEST'  ;
commit;

SPOOL OFF
-- SQL Plus Environment Variables
set echo off
set verify on
set feedback on
set termout on
set time off
set timing off
set heading on
set linesize 100
set pagesize 24
set serveroutput off

PROMPT DONE... Removing DEMOTEST's Rows from schema owner STORET1
set echo on
-- File: DEL_DEMO.SQL
-- @del_demo.sql  -- RE-RUN Script (if applicable)
exit
