Page 1 of 1
error while writing to Oracle
Posted: Thu Dec 07, 2006 2:29 am
by naveenpatil
oesW_CUSTOMER,0: The system(sqlldr scott@orcl CONTROL=ora.2441402.693572.0.ctl LOG=ora.2441402.693572.0.log BAD=ora.2441402.693572.0.log.bad SILENT=header PARFILE=ora.2441402.693572.0.par) failed; see the log file for the Oracle specific message
Posted: Thu Dec 07, 2006 2:33 am
by kumar_s
Is it a message from DS or custom produced error message. What is the desing of the job? When was this error appearing?
Posted: Thu Dec 07, 2006 3:00 am
by ray.wurlod
Look in the Oracle "bad" file and "log" file for additional diagnostic information. This message has been reported by the Oracle bulk loader (sqlldr), not by DataStage. DataStage has simply logged it when it was received.
Posted: Thu Dec 07, 2006 3:05 am
by ajith
Post the error from the Log files mentioned in the Datastage error, as Ray mentioned ...