@echo off

echo "****************************************"
set /p tbFlag="create tablespace or not  Y|N: "
if %tbFlag% == Y (call create_tablespace.bat)

echo "****************************************"
set /p userFlag="create user or not  Y|N: "
if %userFlag% == Y (call create_user.bat)


echo "****************************************"
set /p oracle_user="input impdp oracle user: "

set /p oracle_password="input password: "

set /p oracle_dir="input directory name: "

set /p oracle_dumpfile="input  dump file name: "

set /p remap_schema="input remap schemas.example:sourceUser1:targetUser1 or sourceUser1:targetUser1,sourceUser2:targetUser2: "

set /p remap_tablespace="input remap tablespaces.example:sourceTB1:targetTB1 or sourceTB1:targetTB1,sourceTB2:targetTB2: "

set /p tflag="execute Y|N: "


if  %tflag% == Y (impdp %oracle_user%/%oracle_password% directory=%oracle_dir% dumpfile=%oracle_dumpfile% remap_schema=%remap_schema% remap_tablespace=%remap_tablespace%)