rem ************************************
rem Card Info OC 
rem ************************************
@echo off

Set v_sid=MAGICASH
set /P v_sid="Please enter DATABASE name (default - MAGICASH): "

Set v_username=MAGICASH5
set /P v_username="Please enter User_OC NAME (default - MAGICASH5): "

Set v_pass=NCTMAGICASH5
set /P v_pass="Please enter USER PASSWORD (default - NCTMAGICASH5): "

set v_filename=exp

#rem Card number for export. Multiple cards by comma(,) - 914012937

#set v_cardnum=914012937
#set /P v_cardnum="Please enter cards_num in OC (neskolko kart cherez ","): "


MD results_oc


 
rem *** ECFIL046 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_046.dmp LOG=results_oc\%v_filename%_046.LOG TABLES=(ECFIL046) QUERY=\"where data between to_date('21.03.2023','dd.mm.yyyy') and  to_date('23.03.2023','dd.mm.yyyy')\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem *** ECFIL047 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_047.dmp LOG=results_oc\%v_filename%_047.LOG TABLES=(ECFIL047) QUERY=\"where data between to_date('21.03.2023','dd.mm.yyyy') and  to_date('23.03.2023','dd.mm.yyyy')\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem *** ECFIL067 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_067.dmp LOG=results_oc\%v_filename%_067.LOG TABLES=(ECFIL067) QUERY=\"where data between to_date('21.03.2023','dd.mm.yyyy') and  to_date('23.03.2023','dd.mm.yyyy')\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem *** ECFIL091 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_091.dmp LOG=results_oc\%v_filename%_091.LOG TABLES=(ECFIL091) QUERY=\"where data between to_date('21.03.2023','dd.mm.yyyy') and  to_date('23.03.2023','dd.mm.yyyy')\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem *** ECFIL139 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_139.dmp LOG=results_oc\%v_filename%_139.LOG TABLES=(ECFIL139) QUERY=\"where data between to_date('21.03.2023','dd.mm.yyyy') and  to_date('23.03.2023','dd.mm.yyyy')\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem *** ECFIL144***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_144.dmp LOG=results_oc\%v_filename%_144.LOG TABLES=(ECFIL144) QUERY=\"where data between to_date('21.03.2023','dd.mm.yyyy') and  to_date('23.03.2023','dd.mm.yyyy')\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem *** ECFIL159 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_159.dmp LOG=results_oc\%v_filename%_159.LOG TABLES=(ECFIL159) QUERY=\"where data_formirovaniya >=sysdate - 21\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem *** konfiguraciya ****
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_p5.dmp LOG=results_oc\%v_filename%_p5.LOG TABLES=P5CONFIG GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem *** OC_DB_ERROR_LOG ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_OC_DB_ERROR_LOG.dmp LOG=results_oc\%v_filename%_OC_DB_ERROR_LOG.LOG TABLES=(OC_DB_ERROR_LOG) QUERY=\"where DATE_ERROR >=sysdate - 21\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem *** OC_ONL_TRANSACTIONS_ORIGINAL ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_OC_ONL_TRANSACTIONS_ORIGINAL.dmp LOG=results_oc\%v_filename%_OC_ONL_TRANSACTIONS_ORIGINAL.LOG TABLES=(OC_ONL_TRANSACTIONS_ORIGINAL) QUERY=\"where terminal_date between to_date('21.03.2023','dd.mm.yyyy') and  to_date('23.03.2023','dd.mm.yyyy')\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none
 
rem *** OC_ONL_TRANSACTIONS ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_OC_ONL_TRANSACTIONS.dmp LOG=results_oc\%v_filename%_OC_ONL_TRANSACTIONS.LOG TABLES=(OC_ONL_TRANSACTIONS) QUERY=\"where terminal_date between to_date('21.03.2023','dd.mm.yyyy') and  to_date('23.03.2023','dd.mm.yyyy')\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none
 



zip -rSX9 arc_results_exp_card_info_OC.zip results_oc/