Re: Testing DATE is correct with Oracle Loader

Please specify the bad file name while you do the Load (in your command line)

During the load process records with errors will be thrown into the bad file which can then be manipulated using string processing utilities such as awk/sed or any compilers/interpreters of your choice, data corrected as appropriate and then loaded back into the table.

The error numbers and record number will be in the load log file and data would be in the bad file. You can merge/link them to identify errors and then correct them.

cheers
- Ram

Stefan Duffner wrote:

> Hello,
>
> I have a problem with Oracle Loader and I hope anyone can help me.
> I try to import data from a textfile into Oracle which works
> perfectly.
> But I have some fields of DATE type and in these textfiles have
> sometimes incorrect dates like 33. of month etc.. But I want to put
> these data, which have incorrect date, into a discard file, but I dont
> know how I can check the date and writing it into the discard file.
>
> Thanks for any help
> Stefan
  Received on Wed Aug 08 2001 - 07:03:22 CEST