Re: Easy way to dump table to flat file?
From: ENVIPCO Management Services <envipco_at_cais3.cais.com>
Date: 21 Mar 1995 16:19:41 GMT
Message-ID: <3kmuat$nue_at_news.cais.com>
Date: 21 Mar 1995 16:19:41 GMT
Message-ID: <3kmuat$nue_at_news.cais.com>
Vincent A Ventrone (vv_at_mbunix) wrote:
: A colleague has asked me to describe the easiest way to dump
: an Oracle table to a flat Unix file--and I did not have a ready answer.
: Any suggestions in netland??
: Thanks for any help.
Try starting SQLPLUS, SET PAGESIZE 0, SET LINESIZE 500, SPOOL, then SELECT * FROM tablename
good luck.
Randy - envipco_at_cais.com Received on Tue Mar 21 1995 - 17:19:41 CET