From: Frederic Bidon Subject: RE: How to dump table contents as SQL statements? Date: 2000/02/02 Message-ID: <2D3005375CAED31199D00008C784963F020976@ms02.mobilix.dk>#1/1 Content-Transfer-Encoding: 7bit To: "'comp.databases.oracle.server@list.deja.com'" X-DejaID: _9S5uGRHcNJK/M5LTAB5ODtjf9zO1BieP?= Content-Type: text/plain Organization: Deja.com - Before you buy Mime-Version: 1.0 Newsgroups: comp.databases.oracle.server 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@bisc.eecs.berkeley.edu] Sent: 26. januar 2000 02:40 To: comp.databases.oracle.server@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.