Re: Automatic SQL*Loader control file generation

Greg,

My 'dosql' software will do this.
See <http://www.dondorp.com/dosql.html>
It can create a sql*load controlfile and datafile for a table.

If you're lucky a prebuilt binary is available, Otherwise you can compile the Pro*C code.

Erwin

-- 
Erwin Dondorp
<http://www.dondorp.com/>


Greg Coman wrote:


> To do the reorganisation I'm planning to do the following:

> 1) Unload the table using SQL.

> 2) Sort the unloaded data using the Unix 'sort' command.

> 3) Drop the indexes on the table.

> 4) Load the table using SQL*Loader.

> 5) Rebuild the indexes using 'create index' statements.

> Does anyone know of a generic program / utility that can unload a table