RE: How to dump table contents as SQL statements?

[Quoted] 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

• 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 CET