RE: How to dump table contents as SQL statements?

From: Frederic Bidon <fbi_at_mobilix.dk>
Date: 2000/02/02
Message-ID: <2D3005375CAED31199D00008C784963F020976@ms02.mobilix.dk>#1/1

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