Re: Sql*loader TAB problems

Try set tab off within sqlplus.

Hope this helps Helen

Steve Dodsworth (steven_dodsworth_at_qsp.co.uk) wrote:
: Hello all,
 

: I have a problem with sqlloader or sqlplus.
: I have written a script that will download a table into csv format ready
: for sqlload'ing back into a table.
 

: One of the fields is a char(8) with a data value of 'BG6 '. When this
: field is downloaded and concatenated with the delimiters,
: e.g.
: ^BG6 ^
: Oracle replaces the 5 remaining spaces with a tab and a space (used
: dumpfile to prove it.).
 

: When I sqlload this file back into the table, it inserts the tab after the
: 3 characters thus invalidating and where clause that tries to find it.
: e.g.
: ..where field='BG6 '...
: will fail.
 

: Does any one have the answer to this problem - some setting in sqlloader
: for example.
 

: Any help would be appreciated, thanks
: Steve
Received on Thu Dec 19 1996 - 00:00:00 CET