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(,) -  

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


MD results_oc


rem *** 1 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_001.dmp LOG=results_oc\%v_filename%_001.LOG TABLES=(ECFIL001) GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem ***  2 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_002.dmp LOG=results_oc\%v_filename%_002.LOG TABLES=(ECFIL002) GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem ***  5 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_005.dmp LOG=results_oc\%v_filename%_005.LOG TABLES=(ECFIL005) GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem *** 12 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_012.dmp LOG=results_oc\%v_filename%_012.LOG TABLES=(ECFIL012) GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem *** 15 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_015.dmp LOG=results_oc\%v_filename%_015.LOG TABLES=(ECFIL015) QUERY=\"where ID_KARTY in (Select ID_KARTY FROM ECFIL012 WHERE GR_NOMER in (%v_cardnum%))\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem ***  22 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_022.dmp LOG=results_oc\%v_filename%_022.LOG TABLES=(ECFIL022) QUERY=\"where ID_KARTY in (Select ID_KARTY FROM ECFIL012 WHERE GR_NOMER in (%v_cardnum%))\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem ***  28 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_028.dmp LOG=results_oc\%v_filename%_028.LOG TABLES=(ECFIL028) QUERY=\"where ID_KARTY in (Select ID_KARTY FROM ECFIL012 WHERE GR_NOMER in (%v_cardnum%))\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none
 
rem ***  46 ***  
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 GRAFICHESKI_NOMER in (%v_cardnum%)\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem ***  47 ***  
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 GRAFICHESKI_NOMER in (%v_cardnum%)\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem ***  61 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_061.dmp LOG=results_oc\%v_filename%_061.LOG TABLES=(ECFIL061) GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none
rem ***  67 *** 
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-3\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem ***  91 *** 
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-3\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem ***  139 ***  
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 GR_NOMER in (%v_cardnum%)\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem ***  144***  
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%)\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem ***  159 ***  
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 - 30\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem ***  5****
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 ***    *** 
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_Oc_Onl_Cards_Current.dmp LOG=results_oc\%v_filename%_Oc_Onl_Cards_Current.LOG TABLES=(Oc_Onl_Cards_Current) QUERY=\"where cardnum in (%v_cardnum%)\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

rem ***   *** 
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_Oc_Onl_Cards_Limits.dmp LOG=results_oc\%v_filename%_Oc_Onl_Cards_Limits.LOG TABLES=(Oc_Onl_Cards_Limits) QUERY=\"where cardnum in (%v_cardnum%)\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none
 
rem ***   *** 
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_Oc_Onl_Cards_Params.dmp LOG=results_oc\%v_filename%_Oc_Onl_Cards_Params.LOG TABLES=(Oc_Onl_Cards_Params) QUERY=\"where cardnum in (%v_cardnum%)\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none 
 
rem ***   *** 
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_Oc_Onl_Card_Param_History.dmp LOG=results_oc\%v_filename%_Oc_Onl_Card_Param_History.LOG TABLES=(Oc_Onl_Card_Param_History) QUERY=\"where card_num in (%v_cardnum%)\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none  
 
rem ***   *** 
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_Oc_Onl_Card_Service_History.dmp LOG=results_oc\%v_filename%_Oc_Onl_Card_Service_History.LOG TABLES=(Oc_Onl_Card_Service_History) QUERY=\"where cardnum in (%v_cardnum%)\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none   
 
rem ***   ***  
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%)\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none
 
rem *** tr1****
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_tr1.dmp LOG=results_oc\%v_filename%_tr1.LOG TABLES=TR1 GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

zip -rSX9 arc_results_exp_card_info_OC.zip results_oc/