Re: Newbie sqlload question
From: Reginald W. Bailey <rwbailey_at_usa.net>
Date: 1996/11/13
Message-ID: <01bbd1a5$efe0b270$4b4e8486_at_rbailey>#1/1
Date: 1996/11/13
Message-ID: <01bbd1a5$efe0b270$4b4e8486_at_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 CET