Re: SQL tables to text file

I've also seen this article in asktom.oracle.com:

http://asktom.oracle.com/pls/ask/f?p=4950:8:397449::NO::F4950_P8_DISPLAYID,F4950_P8_B:235814350980,Y

That shows and an example script using utl_file to generate a *.csv file.

"Dmitry" <support_at_ispirer.com> wrote in message news:<9vvba0$i4sf8$1_at_ID-75577.news.dfncis.de>...
> Hi,
>
> You can use migration tool Chyfo (www.ispirer.com/products) to do this. It
> can export data from Oracle and other databases into text files (CSV, TAB
> delimited, SQL INSERT statements). It generates native DDL statements and
> load scripts for Oracle, DB2, MS SQL Server, Sybase and MySQL.
>
> Best regards, Dmitry
>
> "Krzysztof Zielinski" <longinus_at_interia.pl> wrote in message
> news:3C20E995.8CB439C1_at_interia.pl...
> > IS it possible on oracle8 to import the content of the table to the text
> > file, creating the SQL script so to make possible the creation of the
> > database data and structure on different servers? If so, please describe
> > how. Do i need an administration rights to do this?
Received on Sun Jan 13 2002 - 15:57:56 CST