rem ************************************
rem Card Info OC, Last update 29/10/2019
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(,) - 1575000624,1575000626

 set v_cardnum=1575000624,1575000626
#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 *** ECFIL010 ***  
exp userid=%v_username%/%v_pass%@%v_sid% file=results_oc\%v_filename%_010.dmp LOG=results_oc\%v_filename%_010.LOG TABLES=(ECFIL010) 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) QUERY=\"where id_vladeltza = '48'\" 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 id_vladeltza = '48')\" 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 id_vladeltza = '48')\" 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 id_vladeltza = '48')\" 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 (Select gr_nomer FROM ECFIL012  where id_vladeltza = '48')\" 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 (Select gr_nomer FROM ECFIL012  where id_vladeltza = '48')\" 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

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 *** 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 (Select gr_nomer FROM ECFIL012  where id_vladeltza = '48')\" 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 (Select gr_nomer FROM ECFIL012  where id_vladeltza = '48')\" 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_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 *** 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 (Select gr_nomer FROM ECFIL012  where id_vladeltza = '48')\" 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 cardnum in (Select gr_nomer FROM ECFIL012  where id_vladeltza = '48')\" GRANTS=n INDEXES=n ROWS=y CONSTRAINTS=n COMPRESS=n STATISTICS=none
 

rem *** Oc_Onl_Cards_Current *** 
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 *** Oc_Onl_Cards_Limits *** 
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 *** Oc_Onl_Cards_Params *** 
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 *** Oc_Onl_Card_Param_History *** 
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 *** Oc_Onl_Card_Service_History *** 
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   
 

zip -rSX9 arc_results_exp_card_info_OC.zip results_oc/