Re: Oracle utility to export tables

From: Chris Hamilton <ToneCzar_at_erols.com>
Date: Mon, 22 Mar 1999 14:32:10 GMT
Message-ID: <36f653c7.1274051@news.erols.com>

On Mon, 22 Mar 1999 13:58:06 GMT, "Grzesiek" <grzesiek_at_no.spam> wrote:

>mikey wrote in message <7d578k$9ac$1_at_nnrp1.dejanews.com>...
>>Hi all
>>
>>Has anyone out there has some kind of software that will export all the
>data
>>from tables in a schema using insert statements and save it as an sql file
>>
>>for each table
>>ie. insert into table_name values ( all the data)
>> insert into table_name values ( all the data)
>>
>>pls email me at michael.dsouza_at_matsushita-europe.com
>>
>>regards
>>
>>michael
>
>
>Sure. Oracle provides export utility. For example under OpenVMS it can be
>run by 'exp' command.

That's not what he's asking for. He wants a text file (an SQL script) containing the insert statements that can be run in SQL*Plus or other SQL program.

I believe that the TOAD program has this capability (http://www.toadsoft.com/). You can also write one yourself using SQL*Plus.

Chris

---

Chris Hamilton -- toneczar_at_erols.com
Oracle DBA -- Wall Street Sports
http://www.wallstreetsports.com/ Received on Mon Mar 22 1999 - 08:32:10 CST