In Infomaker you can use saverows as sql and it will create a sql script
that has the create table and insert statements.
--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn
Frederic Bidon <fbi_at_mobilix.dk> wrote in message
news:2D3005375CAED31199D00008C784963F020976_at_ms02.mobilix.dk...
> It is indeed a standard export mechanism for MySQL.
> You can write a script that does the job, or either in Oracle 8i parse the
> archive logs generated when loading your table with the Log Miner tool
> (which does generate SQL).
>
> -----Original Message-----
> From: Gopal Santhanam [mailto:gopal_at_bisc.eecs.berkeley.edu]
> Sent: 26. januar 2000 02:40
> To: comp.databases.oracle.server_at_list.deja.com
> Subject: How to dump table contents as SQL statements?
>
>
> Message from the Deja.com forum:
> comp.databases.oracle.server
> Your subscription is set to individual email delivery
>
>
> Hi,
>
> How do you dump the data contents of a table as a series of sql insert
> statements? I'd like to generate a sql script file that can be later
> loaded into an empty incarnation of the same table.
>
> I know there is such an animal in for MySQL.
>
> Gopal
>
>
>
> _____________________________________________________________
> Deja.com: Before you buy.
> http://www.deja.com/
> * To modify or remove your subscription, go to
> http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.server
> * Read this thread at
> http://www.deja.com/thread/%3C86lj8r%24ck8%241%40agate.berkeley.edu%3E
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Feb 02 2000 - 00:00:00 CST
