Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: import to remote machine
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