Xref: alice comp.databases.oracle:74086
From: "David Buttrick" <buttrick@sportingnews.com>
Newsgroups: comp.databases.oracle
Subject: Oracle 7.3.3 on NT loader problem...
Date: Mon, 1 Feb 1999 21:04:48 -0600
Lines: 38
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <36b66bc1.0@news.primary.net>
X-Trace: 1 Feb 1999 21:06:41 -0600, 208.16.29.190
Organization: Primary Network. http://www.primary.net
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news-peer1.sprintlink.net!-program!news-backup-west.sprintlink.net!news.sprintlink.net!news.primary.net!208.16.29.190

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