Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr and discarded records
FC wrote:
> "Christoph Seidel" <christoph.seidel1_at_gmx.de> wrote in message
> news:b4qf62$231hvv$1_at_ID-143718.news.dfncis.de...
> If the loader dies unexpectedly, there should be a mechanism in place
> such that it detects the anomaly of the situation.
> If you are loading data into staging tables, the load failure could
> trigger an action deleting the partially loaded data or taking some
> other "clever" action.
> There are several different methods of loading data, if there are any
> complex business rules and/or sensible data involved, I normally load
> everything in staging tables, minimising the data filtering at the sql
> loader level and deferring it to some more manageable level, like
> stored procedures that can return much more significant error
> messages than sql loader can.
I just load the data into a simple table, no complex stuff. It seems that the ldr does not know that he already has imported something. So i have to adjust the input file or the control file (skip), right? Received on Fri Mar 14 2003 - 04:29:07 CST