Re: ASCII DELIMITED Data File

Brandon Duncan wrote:
>
> To any Oracle Experts:
>
> Is there a clean way to create an ASCII Delmited Data file via ORACLE
> for the purpose of transferring data from one database to another?
> I don't want to mess with the structure at all.
>
> Thanks for you help,
>
> Brandon

	set colsep='|'
	set feedback off
	set pages 0
	set lines <n>   #where n => record length
	set termout off
	spool <file_name.ext>
	select * from <table_name>
	spool off

	I may have missed a parameter or two, but this will get you

-- 
Jerry Gitomer 
Once I learned how to spell DBA, I became one