Re: Spaces loaded as nulls

andrewv_at_devvax.mincom.oz.au
> "When loading from an ACSII file to Oracle, 'spaces' in the ACSII file
>get translated to 'nulls' in the Oracle data set. The guys here have written
>an SQL script that goes through the file converting all the nulls back to
>spaces. Is there a switch or something that can be set so that the spaces are
>in fact loaded as spaces."
>
> I'm not sure what these guyss are using to do the loads (ie. what
>utility, cobol program, c program .......). They are running Oracle 7 on an
>OpenVMS box. Any thoughts?

Sounds to me like they are using sqlldr. The spaces in the datafile are getting translated to nulls by loader itself. Try setting the PRESERVE SPACES keyword in the controlfiles. But be careful, You may preserve more spaces than you had intended.

-- 
Regards, 

Lee E. Parsons                  		
Systems Oracle DBA	 			lparsons_at_world.std.com