Re: sqlldr syntax question

I went through a similar excercise recently, migrating an ingres database to Oracle. I wrote a short C program which interrogated the catalog tables and generated a ctl file for each table.

If you look at OTN you might find tools which already do this kind of thing for Informix as Oracle are very much into helping informix users move to Oracle at the moment. If not, all it requires is a short program to generate the sqlldr control files automatically.

Regards
Priyesh
www.mercurie.co.uk

"Christopher Zarrella" <serge_at_io.com> wrote in message news:akcM8.170853$9F5.9046993_at_typhoon.austin.rr.com...
> We are planning to move from Informix to Oracle. In my research I was
> surprised to discover that plsql does not support the 'load from' syntax
> that is prevalent on many databases (eg Informix, Mysql).
>
> I'm looking at sqlldr, sql loader. My question is whether listing the
> columns of the target table is mandatory even if all of the fields are to
> be populated? Is ( * ) really not ok?
>
> --
> Christopher Zarrella
> serge_at_austin.rr.com
> Linux User
Received on Sun Jun 09 2002 - 20:26:32 CEST