overwritting all .dat,.ctl,.bad,.log file
Posted: 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
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