#!/bin/sh
#*******************************************************************************
#             ISTP REENGENEERING
#         ORACLE RECONSTRUCTION RULES
#               NASA/GSFC
#*******************************************************************************
#PURPOSE: Restores previous state of Reconstruction tables.
#
#INVOCATION METHOD: dly_recon_imp user password system/password import_file_name
#
# EXTERNAL VARIABLES:
# Source                Name               Type   Use  Description
# ----------------------------------------------------------------------------
# buildscript           $recon_base        char    I   location of db build scripts
#
#
#DEVELOPMENT HISTORY:
#
#       Author          Change-ID   Release   Date    Description of Change
#       ------          ---------   ------- --------  ---------------------
#       Y. Azie         Build 1              7/8/93   Initial release
#
#*********************************************************************************
if test $# -ne 4 
then
   echo '*********************************************************'
   echo '    Error, you must enter an Oracle UserID, Password'
   echo '    followed by the system userid/password, and the name of' 
   echo '    the uncompressed inport file from which the data will be imported.'
   echo '*********************************************************'
   exit
fi

sqlplus $1/$2 <<ENDORACLE

-- UNLOAD TABLE DATA FROM AFST INTO AFST_UNDO  
 exec TRUNCATE_OBJECT ('TABLE','AFST_UNDO');
 INSERT INTO AFST_UNDO SELECT * FROM AFST;

-- UNLOAD TABLE DATA FROM IFST INTO IFST_UNDO  
 EXEC TRUNCATE_OBJECT ('TABLE','IFST_UNDO');
 INSERT INTO IFST_UNDO SELECT * FROM IFST;

-- UNLOAD TABLE DATA FROM MNFLT1 INTO MNFLT1_UNDO  
 exec TRUNCATE_OBJECT ('TABLE','MNFLT1_UNDO');
 INSERT INTO MNFLT1_UNDO SELECT * FROM MNFLT1;

-- UNLOAD TABLE DATA FROM MNFLT2 INTO MNFLT2_UNDO  
 exec TRUNCATE_OBJECT ('TABLE','MNFLT2_UNDO');
 INSERT INTO MNFLT2_UNDO SELECT * FROM MNFLT2;

-- UNLOAD TABLE DATA FROM MNFLT3 INTO MNFLT3_UNDO  
 exec TRUNCATE_OBJECT ('TABLE','MNFLT3_UNDO');
 INSERT INTO MNFLT3_UNDO SELECT * FROM MNFLT3;

-- UNLOAD TABLE DATA FROM MNFLT4 INTO MNFLT4_UNDO 
 exec TRUNCATE_OBJECT ('TABLE','MNFLT4_UNDO');
 exec INSERT INTO MNFLT4_UNDO SELECT * FROM MNFLT4;

-- UNLOAD TABLE DATA FROM MNFLT5 INTO MNFLT5_UNDO  
 exec TRUNCATE_OBJECT ('TABLE','MNFLT5_UNDO');
 INSERT INTO MNFLT5_UNDO SELECT * FROM MNFLT5;

-- UNLOAD TABLE DATA FROM MNFFPT INTO MNFFPT_UNDO  
 exec TRUNCATE_OBJECT ('TABLE','MNFFPT_UNDO');
 INSERT INTO MNFFPT_UNDO SELECT * FROM MNFFPT;

-- UNLOAD TABLE DATA FROM SYSTEM_STATE INTO SYSTEM_STATE_UNDO  
 exec TRUNCATE_OBJECT ('TABLE','SYSTEM_STATE_UNDO');
 INSERT INTO SYSTEM_STATE_UNDO SELECT * FROM SYSTEM_STATE;

-- UNLOAD TABLE DATA FROM CS_STATE_REPORT INTO CS_STATE_REPORT_UNDO 
 exec TRUNCATE_OBJECT ('TABLE','CS_STATE_REPORT_UNDO');
 INSERT INTO CS_STATE_REPORT_UNDO SELECT * FROM CS_STATE_REPORT;

DROP TABLE AFST;

DROP TABLE IFST;

DROP TABLE MNFLT1;

DROP TABLE MNFLT2;

DROP TABLE MNFLT3;

DROP TABLE MNFLT4;

DROP TABLE MNFLT5;

DROP TABLE MNFFPT;

DROP TABLE SYSTEM_STATE;

DROP TABLE CS_STATE_REPORT;

COMMIT;
EXIT;

ENDORACLE

imp userid=$3 fromuser=$1 touser=$1 tables=afst,ifst,mnflt1,mnflt2,mnflt3,mnflt4,mnflt5,mnffpt,system_state,cs_state_report file=$4

exit
