I have generated a bunch of expdp commands and stored them in a .cmd file. When I execute one of the commands by copy and paste into a command prompt, it works fine. If I try to execute the whole .cmd file, it also works great.
I need to use PARALLEL and %U, so I have added that to the commands. Again, I run it manually in the command prompt and it works great and honors the %U by creating multiple .dmp files with a sequence number. But when executing the whole .cmd file with the PARALLEL and %U, it does not honor the %U and just creates one .dmp file with _U. How can I fix this so it will create the multiple dmp files?
Here is an example of one of my commands that executes fine when copied and pasted into a command prompt but does not work right when executed as a file.
expdp TEST/PWD@ORCL schemas=TEST directory=EXPORT_DIR parallel=4 REUSE_DUMPFILES=Y dumpfile=TEST_20190906_%U.dmp logfile=TEST_20190906_expdp.log