| Subject: | SQL Loader does not properly implement Direct Load |
In case the loader is given the option
""
direct => 'true'
""
still it does not allow direct path load
This can be easily identified by the time taken in loading huge data or
by the log file that it generates e.g. 'sqlloader.log' in the example below.
my $ldr = new Oracle::SQLLoader(infile => $input_data_file,
badfile => $IgnoredDataFile.".bad",
discard => $IgnoredDataFile.".err",
direct => 'true',
logfile => 'sqlloader.log',
terminated_by => ',',
username => $USER,
password => $PASS,
sid => ,
cleanup => 'false' }
Attaching the updated file which will include direct path load.
| Subject: | SQLLoader.pm |
Message body is not shown because it is too large.