How to export to comma delimited file from Oracle8?
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 UsenetReceived on Mon Sep 29 1997 - 00:00:00 CEST