Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Loader Problem Pls help
For a quick quide to creating a flat file using SQLPlus see
How do I export a database table to a flat file ?
http://www.jlcomp.demon.co.uk/faq/flatfile.html
The sqlldr and External Tables are options available for getting a flat file into Oracle along with the utl_file package which can also be used to read data.
The above methods are in addition to the use of pro* language and ODBC programs which generally are more work to create but offer more control over the data.
HTH -- Mark D Powell -- Received on Tue May 16 2006 - 07:45:07 CDT