Re: Oracle Newbie Question

From: Joost Ouwerkerk <joost.ouwerkerk_at_sickkids.on.ca>
Date: Tue, 08 Dec 1998 18:57:02 GMT
Message-ID: <366d75bf.81598033@resunix.sickkids.on.ca>

SQL*Loader is used only to load data INTO the database, not to output it from the database.

You can simply use SQL*Plus and spool the data to a file:

SET TRIMSPOOL ON;
SET TERMOUT OFF;
SPOOL tabledump;
SELECT * FROM tableOne;
SPOOL off;
SET TERMOUT ON; On Tue, 08 Dec 1998 07:23:59 -0800, MarxR_at_claruscorp.com ("Marx, Robert") wrote:

>Is there any way to dump a table in Oracle 7.3 to a

>flat file...in much the same way that the bcp utility

>can be used in Sybase and SQL Server.

>I would have thought that SQL Loader would allow

>something like this.

>Any help in greatly appreciate.

>Thank you,

>
>
>
> -**** Posted from remarQ, Discussions Start Here(tm) ****-
>http://www.remarq.com/ - Host to the the World's Discussions & Usenet
Received on Tue Dec 08 1998 - 12:57:02 CST