How to export to comma delimited file from Oracle8?

From: <kgrigg_at_acxiom.com>
Date: 1997/09/29
Message-ID: <875562663.10888_at_dejanews.com>#1/1


Hello All!
[Quoted] [Quoted] I am wanting to export the rows from an Oracle 8 database table to a comma [Quoted] delimited file. I have been trying to use the export function in the [Quoted] Enterprise manager. But, when I do this, I get a file that looks like it has information on re-creating the tables, etc, along with the data with 'squares' as a delimiter (seen while looking at the file with WordPad). Where can I look for info on this (a utility or commands from SQL*Plus)?

[Quoted] I am basically wanting to dunp the data out because I am dropping the tables I created while learning, use the new scripts I have written to create proper tablespaces, tables..etc. And then re-load them from these dump files.

[Quoted] Any help greatly appreciated!!

Kelly
kgrigg_at_acxiom.com

[Quoted] ps. Please cc by mail too, our newsfeed here isn't reliable...

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Mon Sep 29 1997 - 00:00:00 CEST

Original text of this message