Xref: alice comp.databases.oracle.server:83004
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: Frederic Bidon <fbi@mobilix.dk>
Newsgroups: comp.databases.oracle.server
Subject: RE: How to dump table contents as SQL statements?
Date: Wed, 2 Feb 2000 09:00:11 +0100
Organization: Deja.com - Before you buy
Lines: 40
Message-ID: <2D3005375CAED31199D00008C784963F020976@ms02.mobilix.dk>
Mime-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
To: "'comp.databases.oracle.server@list.deja.com'"
	 <comp.databases.oracle.server@list.deja.com>
X-Mailer: Internet Mail Service (5.5.2448.0)
X-DejaID: _9S5uGRHcNJK/M5LTAB5ODtjf9zO1BieP?=

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.