Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle utility to export tables

Re: Oracle utility to export tables

From: Emmanuel Bontemps <ebo_at_mgn.net>
Date: Mon, 22 Mar 1999 16:54:20 +0000
Message-ID: <36F675BC.CE5EED9D@mgn.net>


Yes, Platinum SQL Station can do that.
Maybe, it will be cheaper for you to write PL/SQL stored procedures and use a package UTL_FILE to write in OS Files.

regards

mikey a écrit :
>
> 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
>
> Michael Dsouza
> Analyst Programmer
> United Kingdom
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Mar 22 1999 - 10:54:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US