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: Grzesiek <grzesiek_at_no.spam>
Date: Mon, 22 Mar 1999 13:58:06 GMT
Message-ID: <7d5gr1$749$1@euler.softax.com.pl>


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.

Grzesiek Received on Mon Mar 22 1999 - 07:58:06 CST

Original text of this message

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