SQL LOADER and NOT NULL constraint

Oracle 8i for Solaris.

Table A has a NOT NULL column, and its value is white space.

I used the the following statement to create a flat file:

set.....
spool flatfile
select col_1||'ctrl-f'||ctrl_2||'ctrl-f'||col_3 from tableA;
spool off

When I use SQLLDR to load data(for testing), it complains that violate the NOT NULL constraint. What's wrong?

Thanks a lot!!!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 15 1999 - 08:10:06 CST