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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Unload Tables

Re: Unload Tables

From: Boris Oblak <borisoblak_at_hotmail.com>
Date: Sun, 17 Oct 1999 07:25:05 +0200
Message-ID: <7ubmjs$ls9$1@pamir.k2.net>


The easiest way is using SQL-Plus and spool command:

SQL> spool my_file.txt
SQL> set heading off
SQL> set page 0;
SQL> select * from my_table;
SQL> spool off;

--
LP Boris

e-mail:boris.oblak_at_k2.net

reza <reza_at_free4all.co.uk> je v sporočilu novic 38087599_at_news.jakinternet.co.uk napisal ...
> The easiest way I've found is to connect by ODBC to an MS Access Database
> and do it there by Export option
> Reza
> Johan den Boer wrote in message <38081183.67724A82_at_hccnet.nl>...
> >Hi,
> >
> >Does anyone how to unload tables to ascii files.
> >
> >Thanks
> >
> >email : jj.den.boer_at_hccnet.nl
>
>
Received on Sun Oct 17 1999 - 00:25:05 CDT

Original text of this message

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