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

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


MD results_oc


rem *** ECFIL001 ***  
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 *** ECFIL002 ***  
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 *** ECFIL005 ***  
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 *** ECFIL012 ***  
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 *** ECFIL015 ***  
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 *** ECFIL022 ***  
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 *** ECFIL028 ***  
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 *** 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 GRAFICHESKI_NOMER in (%v_cardnum%)\" 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 GRAFICHESKI_NOMER in (%v_cardnum%)\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none

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

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-20\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_ocdb.dmp LOG=results_oc\%v_filename%_ocdb.LOG TABLES=(oc_db_error_log) QUERY=\"where DATE_ERROR >=sysdate-20\" 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 GR_NOMER in (%v_cardnum%)\" 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%)\" 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 - 3\" 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



zip -rSX9 arc_results_exp_card_info_OC.zip results_oc/