Re: SQL*Loader - Commit point reached - logical record count 27

From: Hari Om <hari_om_at_hotmail.com>
Date: 3 Sep 2003 07:57:57 -0700
Message-ID: <d1d5ebe4.0309030657.7839951_at_posting.google.com>


Here is my updated version of my execution.....

SQL> desc h_d_t
Name Type



col1 VARCHAR2(3)
col2 NUMBER(4)
col3 VARCHAR2(8)
col4 VARCHAR2(8)
col5 VARCHAR2(8)

col6 NUMBER(3)
col7 NUMBER(8)
col8 VARCHAR2(1)
col9 NUMBER(10,2)
col10 NUMBER(3)

My control file is:



LOAD DATA
INFILE '/full_path/hdd.csv'
INTO TABLE h_d_t
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (
col1 char "ltrim(rtrim(:col1))",

col2 integer external,
col3 char "ltrim(rtrim(:col3))",
col4 char "ltrim(rtrim(:col4))",
col5 char "ltrim(rtrim(:col5))",

col6 integer external,
col7 integer external,
col8 char "ltrim(rtrim(:col8))",
col9 integer external,
col10 integer external
)

My CSV File (sample)data is as :
120,1992,08221946,02121992,02201992,405,8,,9303.48,0 121,1993,08221946,02121992,02201992,405,,,1303.08,0

I execute my SQL*Loader as follows:



./sqlldr scott/tiger_at_common control=/full_path/test.ctl log=/full_path/test.log discard=/full_path/hdd.dis

SQL*Loader: Release 9.2.0.1.0 - Production on Wed Sep 3 08:33:06 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Commit point reached - logical record count 36
Commit point reached - logical record count 72

----------------------------------------------------------------------

My LOG File is as follows:



Record 1: Rejected - Error on table H_D_T, column COL1. ORA-01460: unimplemented or unreasonable conversion requested

Record 2: Rejected - Error on table H_D_T. ORA-01460: unimplemented or unreasonable conversion requested

Record 3: Rejected - Error on table H_D_T. ORA-01460: unimplemented or unreasonable conversion requeste ....
Record 51: Rejected - Error on table H_D_T. ORA-01460: unimplemented or unreasonable conversion requeste


Questions:


  1. Is the above definition of the Table H_D_T and one in Control file fields proper?
  2. For VARCHAR2 types do I need to specify the length in Control file?
  3. What about NUMBER Datatype columns...? Is declaring them as "INTEGER EXTERNAL" sufficent....? DO I need to typecast them....?
  4. What about NUMBER(10,2)...how do I represent these in Control file...?

Any relate dinformation is appreciated...

THANKS! Received on Wed Sep 03 2003 - 16:57:57 CEST

Original text of this message