
@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_PETROL NAME (default - MAGICASH5): "

Set v_pass=NCTMAGICASH5
set /P v_pass="Please enter USER PASSWORD (default - NCTMAGICASH5): "

set v_filename=exp


MD results_%v_username%


 

exp userid=%v_username%/%v_pass%@%v_sid% owner= %v_username% 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%/
 
 
 
 
 
 
