Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie sqlload question

Re: Newbie sqlload question

From: Reginald W. Bailey <rwbailey_at_usa.net>
Date: 1996/11/13
Message-ID: <01bbd1a5$efe0b270$4b4e8486@rbailey>#1/1

Try changing your SQL Loader file.

LOAD DATA
INFILE catalog.txt (without the quotes) INTO TABLE CATALOG_DB
REPLACE
FIELDS TERMINATED BY ','
(
  PART_NUMBER CHAR,
  PRICE DECIMAL EXTERNAL TERMINATED BY WHITESPACE )

You didn't give SQL*Loader enough information as to what type of data to expect. The datatype statement in the SQL Loader file helps Oracle to convert the data into the corresponding Oracle datatype.

Try it. You may like it.

Reginald Bailey Received on Wed Nov 13 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US