Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Generating SQL script for table filling

Re: Generating SQL script for table filling

From: kiel <kiel_at_webpre.com>
Date: Tue, 19 May 1998 07:56:43 -0500
Message-ID: <3561818B.7C66@webpre.com>


Jan Januska wrote:
>
> Please,
> How do I get quickly (using some tool or script) a SQL script containing
> INSERT commands that fill table.
> Value to insert must be taken from current contain of the table in
> database.
> In other words, I want to export a table in SQL-like dump.
>
> Thanks for help, Jan Januska

Look at the export utility (in Utilities User's Guide), that will allow you to dump a whole table to disk.
With the import utility you can load that table back into the Database.

Hope that's what you were askimg for

Christian Received on Tue May 19 1998 - 07:56:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US