Re: sql*loader puts in in, how do I put it out

Hopefully someone has a better solution, but what I am using is:

	SPOOL datafile.txt
	SELECT * FROM <TABLE_NAME>;
	SPOOL OFF
	SPOOL ld_<table_name>_ctl.ctl
	DESC <TABLE_NAME>
	SPOOL OFF

I then edit the ld_<table_name>.ctl file into a real .ctl file for use by SQL*Loader. It can get tedious when dealing with tables that have a lot of rows, but it does get the job done :-)

Regards

Jerry

TimeVest Inc. wrote:
>
> What command do I use to OUTPUT a database into a format that can
> be easily used by SQL*Loader?
 

-- 
Jerry Gitomer               Since I know how to spell DBA I is one!
jgitomer_at_ictgroup.com
jgitomer_at_p3.net             Opinions are mine not those of ICT Group