Re: Oracle 7.3.3 on NT loader problem...

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" <buttrick_at_sportingnews.com> 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_at_digitalspacesystems.com Received on Tue Feb 02 1999 - 17:05:48 CET