rem ************************************
rem Card Info OC, Last update 2/10/2015
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(,) - 891020730

set v_cardnum=1570015228,1570014224,1570014930,1570013167,1570014221
#set /P v_cardnum="Please enter cards_num in OC (neskolko kart cherez ","): "


MD results_oc



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 >=sysdate-14\" 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 >=sysdate-14\" 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 - 14\" 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_ONL_RCVD_TRN ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_OC_ONL_RCVD_TRN.dmp LOG=results_oc\%v_filename%_OC_ONL_RCVD_TRN.LOG TABLES=(OC_ONL_RCVD_TRN) QUERY=\"where terminal_date>=sysdate-14\" 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-14\" 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 graf_nomer_karti_klienta in (%v_cardnum%) and terminal_date >=sysdate-14\" 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 cardnum in (%v_cardnum%) and terminal_date >=sysdate-14\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none



zip -rSX9 arc_results_exp_card_info_OC.zip results_oc/