Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Flat files and SQLLoader

Re: Flat files and SQLLoader

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Mon, 7 Sep 1998 18:53:04 +0200
Message-ID: <6t12v7$khh$1@newton.a2000.nl>


>Once SQLLoader
>loads them into a table, it also puts in the blanks

This is *not* the normal behavior. Are you using char instead of varchar2? Please post the table description, your SQL*Loader control file and some example data. Of course, getting rid of the blanks solves the problem as well, but like I said: it should be possible to do it with SQL*Loader.

Arjan. Received on Mon Sep 07 1998 - 11:53:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US