Re: How to extract table contents to files?

In article <3ebhrd$h72_at_ctsc.hkbc.hk> btsang_at_ctsc.hkbc.hk (Bosco Tsang) writes:

> How can I extract the content of an oracle 7 table to a text file in the home
> directory (unix version)?

1. Use SQL*Plus

SQL> set head off
SQL> set pagesize 0 linesize 0
SQL> spool $HOME/filename
SQL> SELECT * FROM whatever_table;
SQL> spool off

2. Use Export. The output is an ASCII file, though not very readable.

3. Write your own Pro*C/OCI program to fetch the records and write to

   a file.

--
      ___
     (o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
| Alvin Law .. Project Leader, Applications Division ... Oracle Corporation |
|  Email: alaw_at_us.oracle.com ..... Voice: 415.506.8317 . Fax: 415.506.7299  |
+---------------------------------------------------------------------------+

ORA-03113: end-of-file on communication channel