rem ************************************
rem  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

  

MD results_oc

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-30\" 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%_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/