Re: export to ascii file

from the sql*plus manual

Creating a Flat File

When moving data between different software products, it is sometimes necessary to use a "flat" file (an operating system file with no escape characters, headings, or extra characters embedded). For example, if you do not have SQL*Net, you need to create a flat file for use with SQL*Loader when moving data from Oracle Version 6 to Oracle7.

To create a flat file with SQL*Plus, you first must enter the following SET commands:

SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 80
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF After entering these commands, you use the SPOOL command as shown in the previous section to create the flat file.

-- 
	Scott Kelley (skelley_at_online.disney.com)
	Webmaster/Database Admistrator for Disney Online

/*I don't know what I'm talking about and neither does the Disney Co.*/