@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_strukt


MD results_%v_username%
 
exp userid=%v_username%/%v_pass%@%v_sid% file=results_%v_username%\%v_filename%_%v_username%.dmp LOG=results_%v_username%\%v_filename%_%v_username%.LOG GRANTS=y INDEXES=y ROWS=n CONSTRAINTS=y COMPRESS=n STATISTICS=none
 

zip -rSX9 arc_results_%v_username%.zip results_%v_username%/