Re: Oracle 6 to flat file

It is possible to manipulate/edit an export file from V6, if you have the right editor. It has been a few years, but I have done it. Oracle never supported it, but it is doable.

Back in those days I used EVE on VMS and WordStar (data mode) in DOS. If necessary, I ftp'd the export file (in binary mode) to DOS and edit it there.

You just export the tables, then use the editor to pull the SQL. The data is comma/quote delimited, if I remember correctly.

It is not quick, but it can be very educational.

In article <7m8tim$q83$1_at_autumn.news.rcn.net>,   "Jerry Gitomer" <jgitomer_at_erols.com> wrote:
> Hi Chris,
>
> If Oracle 6 allows you to modify the column separator do this:
>
> SQL> SET COLSEP ,
> SQL> SPOOL my file
> SQL> SELECT * FROM mytable;
> SQL> SPOOL OFF
>
> If Oracle 6 won't let you change the column separator you will
> have to change the select statement to look like:
>
> SQL>SELECT column1||','||column2||','||...||','||column n
>
> You can then use your favorite editor to do any final cleanup on
> the ouput file.
>
> regards
> Jerry Gitomer
>
> Chris Fletcher wrote in message
> <931608204.18959.0.nnrp-09.9e98417d_at_news.demon.co.uk>...
> >Hi
> > Does anybody know how I can 'dump' an Oracle 6 table into a
> flat file ie
> >something like CSV?
> >
> >Any help and or pointers would be really appreciated.
> >
> >
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 12 1999 - 15:53:49 CDT