rem ..\backup\trc_all.sq_                                                                                                                             
-- connect SYSTEM/storet@test                                                                                                                         
show user                                                                                                                                             
set echo off                                                                                                                                          
set termout on                                                                                                                                        
set time on                                                                                                                                           
spool c:\trc_storet1_v12.log                                                                                                                              
set echo on                                                                                                                                           
-- focus directory level: ..\setup                                                                                                                    
-- Delete, remove all rows from STORET Reference Table Data  owner ZZZZZZZZ...                                                                        
-- Truncate Table..., remove all rows from STORET Reference Table Data                                                                                
-- Tables Schema Owner: STORET                                                                                                                        
-- STORET Reports Module v1.2 Tables Below                                                                                                            
-- truncate table STORET.APP_HELP ;                                                                                                                      
-- truncate table STORET.FORMS_HELP ;                                                                                                                    
-- truncate table STORET.HELP_KEYWORDS ;                                                                                                                 
-- truncate table STORET.HELP_RELATED ;                                                                                                                  
-- truncate table STORET.TSRPROJSQ ;                                                                                                                     
-- truncate table STORET.TSRRLIST ;                                                                                                                      
-- truncate table STORET.TSRRPARM ;                                                                                                                      
-- STORET Reports Module v1.2 Tables Above                                                                                                            
--                                                                                                                                                    
-- Tables Schema Owner: STORET                                                                                                                        
-- truncate table STORET.TSMERMSG ;                                                                                                                      
-- truncate table STORET.TSMESTRY ;                                                                                                                      
-- truncate table STORET.TSMFHU ;                                                                                                                        
-- truncate table STORET.TSMGEOPA ;                                                                                                                      
-- truncate table STORET.TSMGEOUN ;                                                                                                                      
-- truncate table STORET.TSMLTHUN ;                                                                                                                      
-- truncate table STORET.TSMMAD ;                                                                                                                        
-- truncate table STORET.TSMNAL ;                                                                                                                        
-- truncate table STORET.TSMPRMVL ;                                                                                                                      
-- truncate table STORET.TSMPROLE ;                                                                                                                      
-- truncate table STORET.TSMPSR ;                                                                                                                        
-- truncate table STORET.TSMRRR ;                                                                                                                        
-- truncate table STORET.TSMSIC ;                                                                                                                        
-- truncate table STORET.TSMVSTC ;                                                                                                                       
-- truncate table STORET.TSRANLEQ ;                                                                                                                      
-- truncate table STORET.TSRBIOPT ;                                                                                                                      
-- truncate table STORET.TSRCHALS ;                                                                                                                      
-- truncate table STORET.TSRCHAR ;                                                                                                                       
-- truncate table STORET.TSRCHTYP ;                                                                                                                      
-- truncate table STORET.TSRCPV ;                                                                                                                        
-- truncate table STORET.TSRCTCA ;                                                                                                                       
-- truncate table STORET.TSRFLDGR ;                                                                                                                      
-- truncate table STORET.TSRLBRMK ;                                                                                                                      
-- truncate table STORET.TSRUOM ;                                                                                                                        
--                                                                                                                                                    
                                                                                                                                                      
-- Tables Schema Owner: STORET1                                                                                                                       
truncate table STORET1.TSMADDR ;                                                                                                                      
truncate table STORET1.TSMALP ;                                                                                                                       
truncate table STORET1.TSMAMDA ;                                                                                                                      
truncate table STORET1.TSMCHKPT ;                                                                                                                     
truncate table STORET1.TSMCPORG ;                                                                                                                     
truncate table STORET1.TSMCSNG ;                                                                                                                      
truncate table STORET1.TSMEADDR ;                                                                                                                     
truncate table STORET1.TSMEISN ;                                                                                                                      
truncate table STORET1.TSMERS ;                                                                                                                       
truncate table STORET1.TSMESTLC ;                                                                                                                     
truncate table STORET1.TSMFCLTY ;                                                                                                                     
truncate table STORET1.TSMFILL ;                                                                                                                      
truncate table STORET1.TSMFSA ;                                                                                                                       
truncate table STORET1.TSMGLL ;                                                                                                                       
truncate table STORET1.TSMGNTXT ;                                                                                                                     
truncate table STORET1.TSMHOLE ;                                                                                                                      
truncate table STORET1.TSMIGUA ;                                                                                                                      
truncate table STORET1.TSMINTVL ;                                                                                                                     
truncate table STORET1.TSMLOG ;                                                                                                                       
truncate table STORET1.TSMOCNLC ;                                                                                                                     
truncate table STORET1.TSMOPNG ;                                                                                                                      
truncate table STORET1.TSMORGAN ;                                                                                                                     
truncate table STORET1.TSMPCOA ;                                                                                                                      
truncate table STORET1.TSMPERSN ;                                                                                                                     
truncate table STORET1.TSMPIPE ;                                                                                                                      
truncate table STORET1.TSMPMGRD ;                                                                                                                     
truncate table STORET1.TSMPMTCT ;                                                                                                                     
truncate table STORET1.TSMPPA ;                                                                                                                       
truncate table STORET1.TSMPPRA ;                                                                                                                      
truncate table STORET1.TSMPRA ;                                                                                                                       
truncate table STORET1.TSMPROGM ;                                                                                                                     
truncate table STORET1.TSMPROJ ;                                                                                                                      
truncate table STORET1.TSMPRPRA ;                                                                                                                     
truncate table STORET1.TSMPSA ;                                                                                                                       
truncate table STORET1.TSMPSRA ;                                                                                                                      
truncate table STORET1.TSMPUMP ;                                                                                                                      
truncate table STORET1.TSMRFLBL ;                                                                                                                     
truncate table STORET1.TSMSCTS ;                                                                                                                      
truncate table STORET1.TSMSOI ;                                                                                                                       
truncate table STORET1.TSMSPRNG ;                                                                                                                     
truncate table STORET1.TSMSTATN ;                                                                                                                     
truncate table STORET1.TSMTBINF ;                                                                                                                     
truncate table STORET1.TSMUOA ;                                                                                                                       
truncate table STORET1.TSMUSER ;                                                                                                                      
truncate table STORET1.TSMVSC ;                                                                                                                       
truncate table STORET1.TSMWELL ;                                                                                                                      
truncate table STORET1.TSMWLE ;                                                                                                                       
--                                                                                                                                                    
                                                                                                                                                      
truncate table STORET1.TSRAAL ;                                                                                                                       
truncate table STORET1.TSRADL ;                                                                                                                       
truncate table STORET1.TSRANLPR ;                                                                                                                     
truncate table STORET1.TSRBRG ;                                                                                                                       
truncate table STORET1.TSRBRGI ;                                                                                                                      
truncate table STORET1.TSRCCGA ;                                                                                                                      
truncate table STORET1.TSRCHDEF ;                                                                                                                     
truncate table STORET1.TSRCHGRP ;                                                                                                                     
truncate table STORET1.TSRCITN ;                                                                                                                      
truncate table STORET1.TSRCLDES ;                                                                                                                     
truncate table STORET1.TSRCPA ;                                                                                                                       
truncate table STORET1.TSRDQL ;                                                                                                                       
truncate table STORET1.TSREOD ;                                                                                                                       
truncate table STORET1.TSRFAFSA ;                                                                                                                     
truncate table STORET1.TSRFAPEA ;                                                                                                                     
truncate table STORET1.TSRFAPRA ;                                                                                                                     
truncate table STORET1.TSRFAQSA ;                                                                                                                     
truncate table STORET1.TSRFDACT ;                                                                                                                     
truncate table STORET1.TSRFDSET ;                                                                                                                     
truncate table STORET1.TSRFLDPR ;                                                                                                                     
truncate table STORET1.TSRFQS ;                                                                                                                       
truncate table STORET1.TSRFQSDP ;                                                                                                                     
truncate table STORET1.TSRFQSPA ;                                                                                                                     
truncate table STORET1.TSRGRCFG ;                                                                                                                     
truncate table STORET1.TSRHCSC ;                                                                                                                      
truncate table STORET1.TSRLAB ;                                                                                                                       
truncate table STORET1.TSRLSPP ;                                                                                                                      
truncate table STORET1.TSROAPA ;                                                                                                                      
truncate table STORET1.TSROAPCA ;                                                                                                                     
truncate table STORET1.TSROLSPA ;                                                                                                                     
truncate table STORET1.TSROPPRD ;                                                                                                                     
truncate table STORET1.TSRPOPA ;                                                                                                                      
truncate table STORET1.TSRRCI ;                                                                                                                       
truncate table STORET1.TSRRLRA ;                                                                                                                      
truncate table STORET1.TSRRQCAF ;                                                                                                                     
truncate table STORET1.TSRRSULT ;                                                                                                                     
truncate table STORET1.TSRSDP ;                                                                                                                       
truncate table STORET1.TSRSMPLE ;                                                                                                                     
truncate table STORET1.TSRSTVST ;                                                                                                                     
truncate table STORET1.TSRTNOD ;                                                                                                                      
truncate table STORET1.TSRTOD ;                                                                                                                       
truncate table STORET1.TSRTPA ;                                                                                                                       
truncate table STORET1.TSRTRIP ;                                                                                                                      
truncate table STORET1.TSRTSA ;                                                                                                                       
--                                                                                                                                                    
                                                                                                                                                      
spool off                                                                                                                                             
set echo off                                                                                                                                          
set termout on                                                                                                                                        
PROMPT ********************************************************************                                                                           
PROMPT **                                                                **                                                                           
PROMPT **      All Rows removed from Reference Data is complete.         **                                                                           
PROMPT **                                                                **                                                                           
PROMPT ********************************************************************                                                                           
set termout off                                                                                                                                       
exit                                                                                                                                                  
                                                                                                                                                      
