I have a table with 2 columns..... CREATE TABLE TEST ( ID NUMBER(5), NAME VARCHAR2(30)) My data file looks like the following and ' ' is the col delimiter 10 -- single space 20 -- 5 spaces 30 \ -- back slash followed by a single space 40 -- 0 spaces