1.

Solve : Batch file won't stop executing old code?

Answer»

I have a simple batch FILE I want to execute.

BATCH 1
set mydate=%date:~4,2%%date:~7,2%%date:~10,4%
expdp system/pwd full=Y directory=EXPORT_DIR dumpfile=full_backup_%mydate%.dmp logfile=full_backup_%mydate%.log
cls
exit

When executing it, it does not execute the code correctly and appears to go through a execution loop. What is even stranger, is that I then CREATE a BATCH 2

BATCH 2
expdp help=y

and send the output to a log file. The first line is the code for BATCH 2, but the rest of the log file is repeating lines from the prior BATCH 1 file I executed EARLIER. Below is the log file.

C:\>expdp help=y

C:\>set mydate=05082009
C:\>expdp system/oracle01 full=Y directory=EXPORT_DIR dumpfile=full_backup_05082009.dmp logfile=full_backup_05082009.log
C:\>set mydate=05082009
C:\>expdp system/oracle01 full=Y directory=EXPORT_DIR dumpfile=full_backup_05082009.dmp logfile=full_backup_05082009.log
....................................... ..repeated
....................................... .

and the log file will not stop repeating the prior batch file until I x out the cmd prompt. Any ideas? I have no idea, but a similar THING happened to me.
I now have a screen full of random .dll files on my desktop as a result of playing around with /a switch file creation.

If anyone has an answer, I'd be glad to hear about it as well.Bump. Please rename BATCH 1 to test.bat
Don't use expdp.bat or expdp.cmdQuote from: Batcher on May 11, 2009, 11:41:12 PM

Please rename BATCH 1 to test.bat
Don't use expdp.bat or expdp.cmd
That was it! Thanks!


Discussion

No Comment Found