overwritting all .dat,.ctl,.bad,.log file

adams06 · Post by **adams06** » Sat Mar 16, 2013 8:14 pm

I need to run a server job with sqlldr twice with different source file.

When job1 runs it create .dat,.ctl,.bad,.log file

When job2 run it is overwritting all .dat,.ctl,.bad,.log file

How to handle this situation?

I can simply rename the file names., But i don't want to do that.

Any help to handle it

prasannakumarkk · Post by **prasannakumarkk** » Sat Mar 16, 2013 8:37 pm

in the sqlldr command you have the option of specifying where the dat, log file should be written with file name.

While specifying the file name in the option append the value of macro DSJOBSTARTTIMESTAMP. So each time new file will be created

chulett · Post by **chulett** » Sat Mar 16, 2013 8:55 pm

What stage are you using for this - the OraBulk stage? So that you are manually issuing the sqlldr command? Since the files cannot be appended to, you'll either need to rename them after job or perhaps pass in a job parameter to use when naming the files so they are unique, either to the file or to each run.