oracle sql*loader with a long field

From: <mani.allu_at_mci.com>
Date: 1997/10/20
Message-ID: <877382415.18249_at_dejanews.com>#1/1

I am trying to load a 'long field from a .dat file using sql*loader. Some of the records are getting rejected due to error "Field in data file exceeded maximum specified length".

When I specify the field in the control file as CHAR, I am not getting any errors but no data is getting loaded.

can anybody help me in this!

thanks in advance

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Mon Oct 20 1997 - 00:00:00 CEST

This message: [ Message body ]
Next message: Robert Pollard: "Re: ODBC to Oracle on Sun Solaris - Advice needed..."
Previous message: mani.allu_at_mci.com: "[Reposted due to Enlow UCE cancel]: oracle sql*loader with a long field"
Next in thread: Thomas Kyte: "Re: oracle sql*loader with a long field"
Reply: Thomas Kyte: "Re: oracle sql*loader with a long field"
Reply: Michael Krolewski: "Re: [Reposted due to Enlow UCE cancel]: oracle sql*loader with a long field"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message