Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle utility to export tables
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