Re: How to export to comma delimited file from Oracle8?

Hi

If it only the data in the tables you want and not the structures (Tables, Indexes etc)
then you can still use the normal Oracle Export Utility.

All yo have to do then is to drop the Tablespaces. You must then recreate the Tablespaces, Tables with the correct Storage Parameters. Then you must import them from the Export file which you created.

You must remember to add IGNORE=Y to you Import statement. What this does is it will not import the object definitions if they already exist but it will import the data.

Once this is done you can create the Indexes with the correct Parameters.

Cheers
akader_at_health.sanlam.co.za

kgrigg_at_acxiom.com wrote in article <875562663.10888_at_dejanews.com>...
> Hello All!
> I am wanting to export the rows from an Oracle 8 database table to a
 comma
> delimited file. I have been trying to use the export function in the
> 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)?
>
> 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.
>
> Any help greatly appreciated!!
>
> Kelly
> kgrigg_at_acxiom.com
>
> 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 Tue Sep 30 1997 - 00:00:00 CEST