Re: SQL*Loader - Commit point reached - logical record count 27
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.....
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:
- Is the above definition of the Table H_D_T and one in Control file fields proper?
- For VARCHAR2 types do I need to specify the length in Control file?
- What about NUMBER Datatype columns...? Is declaring them as "INTEGER EXTERNAL" sufficent....? DO I need to typecast them....?
- 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