| load "N/A" HELP pls [message #70259] |
Thu, 16 May 2002 02:00  |
kullawat
Messages: 3
Registered: April 2002
|
Junior Member |
|
|
if my data is
--------------------------------------
column1(NUMBER)
2.36
2.56
N/A
N/A
5.6
...
--------------------------------------
how can I load N/A into table
I try to create controlfile to load this
LOAD DATA
INTO TABLE MyTable
( column1 char terminte by whitespace)
but it send "ORA-01722: invalid number"
help me pls
|
|
|
|
| Re: load "N/A" HELP pls [message #70260 is a reply to message #70259] |
Thu, 16 May 2002 02:40  |
Sujit Mahapatra
Messages: 19
Registered: March 2002
|
Junior Member |
|
|
What I would do is replace all the N/A with NULL. By
NULL I do not mean a string 'NULL'.
I mean simply delete all the entries having the value
as 'N/A'. Open the data file with some editor and
replace all N/A with nothing.
Try running again. It is bound to work...
(not sure whether you have more columns in the loader
script. It seems not. If there are more, then you have
to take care as what you are replacing your N/A string
with. That would depend on the delimiter. If there is
no delimiter and it is fixed width field, then replace
the N/A field with appropriate number of blank spaces
to synchronize with the subsequent fields.
Cheers,
Sujit
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
