Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: sql*loader datatype question

RE: sql*loader datatype question

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Thu, 30 Aug 2001 11:04:18 -0700
Message-ID: <F001.0037DC52.20010830111553@fatcity.com>

how about a cut of the 10 chars, then grep looking for A-Z, a-z in whats left.
 
joe
>>> lisa.koivu_at_efairfield.com 08/30/01 02:58PM
>>>

Yup, looked at that too. 
Unfortunately the record is 1500 characters long.  That's a lot to just eyeball. 
Thanks
  -----Original Message----- <FONT
  face=Arial size=1>From:   Igor
  Neyman [SMTP:ineyman_at_perceptron.com] <FONT face=Arial   size=1>Sent:   Thursday, August
  30, 2001 2:31 PM <FONT face=Arial
  size=1>To:     Multiple
  recipients of list ORACLE-L <FONT face=Arial   size=1>Subject:        <FONT
  face=Arial size=1>Re: sql*loader datatype question   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:   

    if one or more records are rejected, the bad     file is logged.
   Igor Neyman, OCP
  DBAPerceptron, Inc.(734)414-4627<FONT face=Arial   color=#0000ff>ineyman_at_perceptron.com <<A   href="mailto:ineyman_at_perceptron.com">mailto:ineyman_at_perceptron.com><FONT   face=Arial> 

Received on Thu Aug 30 2001 - 13:04:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US