Xref: alice comp.databases.oracle.server:83087
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!cyclone.bc.net!newsfeed.telusplanet.net!news0.telusplanet.net.POSTED!not-for-mail
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Newsgroups: comp.databases.oracle.server
References: <2D3005375CAED31199D00008C784963F020976@ms02.mobilix.dk>
Subject: Re: How to dump table contents as SQL statements?
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <4d_l4.97499$n3.2097822@news0.telusplanet.net>
X-Trace: news0.telusplanet.net 949514176 207.229.11.113 (Wed, 02 Feb 2000 10:56:16 MST)
NNTP-Posting-Date: Wed, 02 Feb 2000 10:56:16 MST
X-Sender: firstbap@0
Date: Wed, 02 Feb 2000 17:56:16 GMT

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@mobilix.dk> wrote in message
news:2D3005375CAED31199D00008C784963F020976@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@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.