Re: How to load a complete empty record using sqlldr?

Can you post a copy of your .ctl file. It may give us clues why. Have you used the trailing nullcols option?

M

ewong74_at_netscape.net wrote in message <7jmq9a$126$1_at_nnrp1.deja.com>...
>Hi there,
>
>I have a ascii data file(separated by |) with 2 fields and thousands of
>rows. One of the rows(the first row) is completely empty. The data
>file looks like:
>
>|
>aaa|bbb
>ccc|ddd
>eee|fff
>
>If I do a load using sqlldr, the first record(the one completely empty)
>are always discarded. Is there a way to load a completely empty row
>using sqlldr? You may ask why I need to load a empty record into the
>db. This is for some data relationship purpose that I must do. And I
>don't want to do a insert ... values ('','') every time after the db is
>refreshed.
>
>Thanks!
>
>Ed
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jun 10 1999 - 03:42:21 CDT