Sqlldr error ...
Posted: Mon Feb 04, 2008 2:37 pm
Hi forum !!
My job is running in an AIX server with DS EE v 7.5.2, now i trying to insert record into oracle using the oracle enterprise plug in. In the sequential file i set the attribute Read First Rows = 150000 and run and insert without problems.
I change the value to 350000 and my job abort 30 minuts later, the error shown is the next
"Oracle_Enterprise_216,0: The call to sqlldr failed; the return code = 589,833; please see the loader logfile: /stag/parallel/node1/Scratch/ora.618582.967574.0.log for details."
This log file is empty, and search the forum for this problem, and i apply the changes for environment variables, in the dsenv file was commented the oracle variables, but the error appear when the value is increased ...
Anybody has an idea about this problem???
Thanks for your help.
My job is running in an AIX server with DS EE v 7.5.2, now i trying to insert record into oracle using the oracle enterprise plug in. In the sequential file i set the attribute Read First Rows = 150000 and run and insert without problems.
I change the value to 350000 and my job abort 30 minuts later, the error shown is the next
"Oracle_Enterprise_216,0: The call to sqlldr failed; the return code = 589,833; please see the loader logfile: /stag/parallel/node1/Scratch/ora.618582.967574.0.log for details."
This log file is empty, and search the forum for this problem, and i apply the changes for environment variables, in the dsenv file was commented the oracle variables, but the error appear when the value is increased ...
Anybody has an idea about this problem???
Thanks for your help.