Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: import to remote machine

Re: import to remote machine

From: Robert Schöller <schoeller_at_inat.at>
Date: Fri, 16 Feb 2001 13:08:39 +0100
Message-ID: <ps5q8tkbg8sf6634kldipbjau0thkpjhlc@4ax.com>

On 16 Feb 2001 11:08:03 GMT,
jms%email.de%email.de%email.de_at_bromo.email.ch (Jens Manfredson) wrote:

>What does that mean ? Are you talking about WinNT ?
>Spooling from the source to a file ?

We are talking about SQL*Plus:

SET HEADING OFF
SPOOL <filename>
SELECT * FROM <tablename>
SPOOL OFF Delete the blank lines and the first & last line from the file and import it with SQL*Loader...

Ing. Robert Schöller (schoeller_at_inat.at) Received on Fri Feb 16 2001 - 06:08:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US