I have a dump file located on the data_pump_directory on server "A" for example. I want to make a bat file on my local laptop that prompts me for the dump file name and import data pump to server "A".
I tried and succeeded to make other bat files that create drop and give grants to users (on server A), but the IMPDP and the EXPDP bats don't work.
My bat file looks like the following:
set /p dumpfile= enter dump name:
C:
cd /
IMPDP system/******@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=**.*.**.***)(Port=1521))(CONNECT_DATA=(SID=****))) DUMPFILE="%dumpfile%.dmp" LOGFILE="%dumpfile%.log" SCHEMAS=('****') DIRECTORY=DATA_PUMP_DIR CONTENT=ALL TABLE_EXISTS_ACTION=REPLACE
pause