| 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
