Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to dump tables to text file from SQLPLUS
No there isn't
You could of course always do something like this
set colsep '|'
set heading off
set pagesize 0
spool tab.out
select *
from table;
spool off
or use toad, toal for oracle application developers, (www.toadsoft.com) to accomplish this task.
Hth,
--
Sybrand Bakker, Oracle DBA
Lou Leclerc <louis_s_leclercNOloSPAM_at_yahoo.com.invalid> wrote in message
news:00372b38.2bcd88be_at_usw-ex0102-010.remarq.com...
>
> In Ingres there is a command in their sql interpreter called
> "copy", that makes straight text dumps of tables into a file system
> text file.
>
> Is there a similar way to do this in the oracle environment SQLPLUS
> as it does not seem to be evident from the manuals.
>
> Thank You;
>
> Lou Leclerc
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu Jan 20 2000 - 03:02:37 CST