Page 1 of 1
Job still running
Posted: Wed Jul 25, 2007 8:19 pm
by rafidwh
Hi All,
I am loading into oracle table from a Dataset.
But the job never completes and in the director it doesn't show up any wanings or any status message ,it shows in the running stage.
Please share your knowledge on this...
Regards,
Rafidwh
Re: Job still running
Posted: Wed Jul 25, 2007 9:26 pm
by g_rkrish
rafidwh wrote:Hi All,
I am loading into oracle table from a Dataset.
But the job never completes and in the director it doesn't show up any wanings or any status message ,it shows in the running stage.
Please share your knowledge on this...
Regards,
Rafidwh
Did you check with your Database to check any deadlocks....
Re: Job still running
Posted: Wed Jul 25, 2007 9:27 pm
by kausikMitra
Since you are using Oracle Stage, its doing Bulk load by using SQLLDR internally. You have to set an APT value for SQLLDR this by giving value (DIRECT=FALSE, PARALLEL=TRUE) and make the index option maintenance.
Pls let me know how it goes.
Posted: Wed Jul 25, 2007 11:36 pm
by ray.wurlod
There is NO WAY this question belongs in the server forum.