Home » RDBMS Server » Server Utilities » Sqlldr (SQL*Loader: Release 9.2.0.5.0,Unix)
Sqlldr [message #348073] Mon, 15 September 2008 09:45
varadha7
Messages: 3
Registered: February 2007
Junior Member
Hi,

I'm trying to Load a file(.dat) that contains decimal characters
and getting the following error.

The column in table is of type NUMBER(20,4)

ORA-01722: invalid number

Data:
=======
12056500
49460.00
875700.00
224179484.01
2744574137.05
3457837476.08
0.00
464800.00
2082100.00
0.00
5826741.00
39198973.0
2547191.00
61800.000
14967145.0
351700.00
281675.00
557900.00
15077100.0
1560800.00

Control file:
============
OPTIONS(DIRECT=TRUE,PARALLEL=TRUE,skip_index_maintenance=TRUE,skip_unusable_indexes=TRUE)
UNRECOVERABLE LOAD DATA
CHARACTERSET VN8MSWIN1258
INFILE 'TEST.dat'
BADFILE 'TEST.BAD'
APPEND
INTO TABLE TEST1
FIELDS TERMINATED BY '~' OPTIONALLY ENCLOSED BY '^'
TRAILING NULLCOLS
(
"CUR_BAL" DECIMAL EXTERNAL(21)
)

Log File:
==========
SQL*Loader: Release 9.2.0.5.0 - Production on Th\375\354Hai Th\341ng Ch\355n 15 20:29:45 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Control File: TEST.ctl
Character Set VN8MSWIN1258 specified for all input.

Data File: TEST.dat
Bad File: TEST.bad
Discard File: none specified
(Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation: none specified
Path used: Direct - with parallel option.

Load is UNRECOVERABLE; invalidation redo is produced.

Table TEST1, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
"CUR_BAL" FIRST 21 ~ O(^) CHARACTER

Record 2: Rejected - Error on table TEST1, column "CUR_BAL".
ORA-01722: invalid number

Record 3: Rejected - Error on table TEST1, column "CUR_BAL".
ORA-01722: invalid number

.............




The NLS_NUMERIC_CHARACTERS = ., set as above.

Pls help

[Updated on: Mon, 15 September 2008 10:28]

Report message to a moderator

Previous Topic: Export log error
Next Topic: Sqlloader and multibyte charset
Goto Forum:
  


Current Time: Wed Dec 07 22:24:05 CST 2016

Total time taken to generate the page: 0.09219 seconds