Oracle 7.3.3 on NT loader problem...
From: David Buttrick <buttrick_at_sportingnews.com>
Date: Mon, 1 Feb 1999 21:04:48 -0600
Message-ID: <36b66bc1.0_at_news.primary.net>
Has anyone got any experience using the loader facility?
Date: Mon, 1 Feb 1999 21:04:48 -0600
Message-ID: <36b66bc1.0_at_news.primary.net>
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 Received on Tue Feb 02 1999 - 04:04:48 CET