Xref: alice comp.databases.oracle:74088 Path: alice!news-feed.fnsi.net!netnews.com!nntp.abs.net!newshub2.home.com!newshub1.home.com!news.home.com!news.rdc1.on.wave.home.com.POSTED!not-for-mail From: darrell-o@home.com (deo) Newsgroups: comp.databases.oracle Subject: Re: Oracle 7.3.3 on NT loader problem... Message-ID: <36b7223e.3434428@news.flfrd1.on.wave.home.com> References: <36b66bc1.0@news.primary.net> X-Newsreader: Forte Agent 1.5/32.452 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 51 Date: Tue, 02 Feb 1999 16:05:48 GMT X-Complaints-To: abuse@home.net X-Trace: news.rdc1.on.wave.home.com 917971548 24.112.91.52 (Tue, 02 Feb 1999 08:05:48 PDT) NNTP-Posting-Date: Tue, 02 Feb 1999 08:05:48 PDT Organization: @Home Network Canada Paste a copy of your Control file (*.ctl) and I can take a look at it. Cheers, Darrell O'Donnell On Mon, 1 Feb 1999 21:04:48 -0600, "David Buttrick" wrote: >Has anyone got any experience using the loader facility? > >I have been using it with great luck over the last 3 days, except for 1 >table: > >Here is the schema: > >create table arcclass ( >partnumber varchar(20) primary key, >sizein varchar(10), >sizemm varchar(10), >drilldiain number, >drilldiamm number, >rodsize varchar(10), >ploadlb number, >ploadkn number); > >here is a sample of the data that I trying to load: > >ARC-25-175-RH25|1/4" x 13/4"|6 x 44|0.1875|5|1/4"-20|500|2.3| >ARC-31-200-RH37|5/16" x 2"|8 x 51|0.25|6|3/8"-16|500|2.3| >ARC-31-200-SW37|5/16" x 2"|8 x 51|0.25|6|3/8"-16|500|2.3| >ARR-T|Standard Rapid Rod Tool||||||||| >ASW-T|Sidewinder Tool|||| > >the laoder insists that the number columns are not correctly formed numbers, >and the load fails. > >I have other datafiles, and tables that have numbers in them, and the files >are formed like this one. > >Am I overlooking something here, or does somebody know something I don't? > >Thanks! > >David Buttrick > Darrell O'Donnell Lead Systems Developer Digital Space Systems Inc. d_odonnell@digitalspacesystems.com