Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader - Commit point reached - logical record count 27
Here is my updated version of my execution.....
SQL> desc h_d_t
Name Type
col3 VARCHAR2(8) col4 VARCHAR2(8) col5 VARCHAR2(8)
My control file is:
col3 char "ltrim(rtrim(:col3))", col4 char "ltrim(rtrim(:col4))", col5 char "ltrim(rtrim(:col5))",
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:
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 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:
Any relate dinformation is appreciated...
THANKS! Received on Wed Sep 03 2003 - 09:57:57 CDT