Re: How to create sqlldr import files?

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Fri, 15 Sep 2000 20:24:01 GMT
Message-ID: <8pu0g7$l97$1@nnrp1.deja.com>

In article <8ptefu$umf$1_at_nnrp1.deja.com>, wax_man_at_my-deja.com wrote:
> Can someone explain how I can create the proper import files for
sqlldr
> from the data in my database (i.e. a sqlldr "dump" file)? I'm still
> trying to get my import/export to speed up, and I want to try the
> sqlldr path. However, this is unexplored teritory for me.
>
> Thanks,
>
> wax_man
>

I used to spool tables into file using sqlplus. sqlldr control files were created manually, because I didn't use this procedure for many tables. I think you can create them from sqlplus too, querying dba_tab_columns table.

> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 15 2000 - 15:24:01 CDT