Re: SQL LOADER and NOT NULL constraint

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 15 Dec 1999 17:59:30 +0800
Message-ID: <38576682.19CD@yahoo.com>

ibm_97_at_yahoo.com wrote:
>
> 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.

Check the PRESERVE BLANKS section in the SQL Loader reference...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Dec 15 1999 - 03:59:30 CST