set /P Service_Name=Enter the Service_Name of Database:
sqlplus scott1/tiger@'%Service_Name%' @copy_user_sql.sql
echo   ******Ready to Export the Data of OLD_USER******
echo   ================================================

set /P Old_UserName=Enter Old Username:
set /P New_UserName=Enter New Username:
set /P FileName=Enter Dumpfile Name:
set /P ServiceName=Enter Service Name:

expdp scott1/tiger@'%ServiceName%' file='%FileName%.dmp' directory=DATA_PUMP_DIR logfile='%FileName%_exp.log' schemas=%Old_UserName% exclude=statistics

echo   ******Ready to Import Data into NEW_USER******
echo   ================================================

impdp scott1/tiger@'%ServiceName%' file='%FileName%.dmp' directory=DATA_PUMP_DIR logfile='%FileName%_imp.log' REMAP_SCHEMA= %Old_UserName%:%New_UserName% 
cmd

set /P Service_Name=Enter the Service_Name of Database:
set /P Old_UserName=Enter Old Username:
set /P Old_UserPassword=Enter Old User Password:
set /P Database_link=Enter the Database link name:
sqlplus %Old_UserName%/%Old_UserPassword%@'%Service_Name%' 

create public database link %Database_link% connect to %Old_UserName% identified by %Old_UserPassword% using %Service_Name%;

echo   ******Ready to Export the Data of OLD_USER******
echo   ================================================

set /P Old_UserName=Enter Old Username:
set /P New_UserName=Enter New Username:

echo   ******Ready to Import Data into NEW_USER******
echo   ================================================

impdp %Old_UserName% directory=DATA_PUMP_DIR REMAP_SCHEMA= %Old_UserName%:%New_UserName% NETWORK_LINK=%Database_link% exclude=STATISTICS 
cmd