Raphael Duenas <raf_at_srd.fr> wrote in message news:<3BD6641B.5C73A57B_at_srd.fr>...
> 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
Question: did you define the file to sqlldr as fixed format or delimited by '|'?
It would have probably helped if you had posted the sqlldr control statements.
Received on Wed Oct 24 2001 - 08:35:26 CDT
