Error while loading data into a table using fastload utility
Hi, I am trying to load two records from a notepad into a table using fastload utility, its working fine if there is a single record, but when i add a newlinechar(char(1)), if am getting the below error.
0006 insert into samples.saat3 (:name, :id);
Number of recs/msgs: 3780 Starting to send to RDBMS with 1 record Incorrect number of bytes returned from a File Read! Expected: 12, Received:2
The below are the scripts used:
Records present in the notepad: raghu 300 | ram 200 |
Scripts in fastload utility .logon 127.0.0.1/dbc,dbc;
create table samples.saat3 (name char(5), id char(3) );