| SQL Loader.again [message #74245] |
Tue, 19 October 2004 06:41 |
patrice
Messages: 5
Registered: October 2001
|
Junior Member |
|
|
-
Hi Everyone,
Im am populating a Oracle Table with Data in a flat file.My Script look like this:
Load Data
infile file.txt
into Table table_name
insert fields terminated by "|" trailing nullcols
( column1 DATE 'yyyy/mm/dd',
column2 char,
.....
column10 char,
column11 decimal external,
column12 integer external)
and and received the Message:
Record1:Rejected...
Record2:Rejected.....
........
ORA-01861:Lieteral does not match format string.
In the Oracle Table destination ,I defined column10 VARCHAR2(10).
I am using Oracle Release 9.2.0.1.0.
Can someone help me?
Thanks.
-
<A name=followups>
[/url]
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
