Lisa,
Try to specify 'BADFILE' when using SQL*LOADER, should help
you to find bad record.
From FM:
When SQL*Loader executes, it can create a file called a bad file or reject file in which it
places records that were rejected because of formatting errors or because they
caused Oracle errors. If you have specified that a bad file is to be created,
the following applies:
|
Title: sql*loader datatype question
- sql*loader datatype question Koivu, Lisa
- Re: sql*loader datatype question JOE TESTA
- RE: sql*loader datatype question Igor Neyman
- RE: sql*loader datatype question Koivu, Lisa
- RE: sql*loader datatype question JOE TESTA
- Re: sql*loader datatype question Ron Rogers
- RE: sql*loader datatype question Bala, Prakash
- Re: sql*loader datatype question DBarbour
- RE: sql*loader datatype question Koivu, Lisa
- RE: sql*loader datatype question Koivu, Lisa
- RE: sql*loader datatype question Mercadante, Thomas F
- RE: sql*loader datatype question Henry Poras
- RE: sql*loader datatype question Weaver, Walt