Re: How to Import/Export Data To-From Oracle 8i Tables

Randall,

Thanks for the info. Its extremely useful.

Makes complete sense.

Are there alternate commands to reverse the process on loading a table from an ASCII delimited file.
In a sense where a file is opened then a subsequent Insert Into tablename Select col1,col2,col3 etc from delimited file.?

Thanks in advance.

Ray.

Randall Roberts wrote:
>
> Ray;
>
> As you've noticed, Oracle import and export are not what one normally thinks
> of as imports and exports. They use a proprietary format. And as I guess
> you've also noticed, SQL*Loader only goes into the database, not out.
>
> I see your question come up frequently and the answer always seems to come
> around to this; write a select statement that embeds the commas, tabs, or
> whatever and spool it to a text file.
>
> SPOOL comafile.txt
>
> SELECT col1 || ',' || col2 || ',' || col3...
> FROM table
>
> SPOOL off
>
> I first spool a DESC table to a text file so that I have all the column
> names to edit down into my select. But the short answer to your question
> is, no I don't know of a third party tool that just takes the table name and
> will do it for you.
>
> Best!
>
> Randall
>
> Ray Vonhollen <RVONHOLLEN_at_pacbell.net> wrote in message
> news:3B0AE616.142968C6_at_pacbell.net...
> > Is there any command line utility, similar to bcp (bulk copy program)
> > that one can use to Import and or Export data from Oracle 8i tables?
> > Usually format is csv, pipe delimited or tab delimited text files.
> >
> > Thanks in advance for your help.
> >
> >
> > Ray
Received on Sat Jul 21 2001 - 23:43:27 CEST