Re: generating flat files with no blank caracters

Ed Prochak a écrit :

> Please give more details. SQL Loader can ignore blanks easily. so what
> really is the problem??

An example of a line to load :
" 9| 10| 2| 4|"

it's the look of my flat file, so when i want to load this, sqloader tell me that the numbers colums are not valid ORA-1722 not a valid number. I want only unload a part or the totality of a table for load it into an other database.

>
>
> Raphael Duenas wrote:
> >
> > Hi,
> >
> > I want to generate a flat file so i can use it for partial loads on over
> > databases, but when i do it with sqlplus, number's columns are completed
> > with blank caracters and the file can't be use with sqloader. So how i
> > should do to get a no blank car file.
> >
> > thanks
> >
> > Raphaël
> > Dijon/FRANCE
Received on Wed Oct 24 2001 - 01:47:55 CDT