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.....
SQL> desc h_d_t
My control file is:
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)
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