Re: exporting/importing tables

why not use:

create table y as select * from x;

and depending on your version you could even the use the unrecoverable command ( create table y as select * from x unrecoverable;) which will not create redo and allow your statement to complete much quicker...

don't forget to re-create the indexes...

good luck

Robert Prendin
Thomas Golob <golob_at_netsolut.com> wrote:

>This is a multi-part message in MIME format.
>--------------1C8038EADE773AE2F65D8BD2
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>Hi all,
>
>is it possible to export the data of a certain table 'x'
>and to import the same data in another table 'y' with the
>same structure?
>
>Thanks in advance
>Thomas
>--------------1C8038EADE773AE2F65D8BD2
>Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Thomas Golob
>Content-Disposition: attachment; filename="vcard.vcf"
>
>begin: vcard
>fn: Thomas Golob
>n: Golob;Thomas
>org: Netsolut
>adr: Eckenheimer Landstr. 449;;;Frankfurt;;60435;Germany
>email;internet: golob_at_netsolut.com
>tel;work: 069/95421220
>tel;fax: 069/95421217
>note;quoted-printable:<hr size=3D1><a href=3D"http://www.netsolut.com"><img src=3D"http://www.n=
> etsolut.com/images/netsolut400.gif" width=3D200 border=3D0></a><br>=0D=0A=
> <a href=3D"http://www.netsolut.com">http://www.netsolut.com</a><br>=0D=0A=
> <a href=3D"http://www.branchenbuch.com">http://www.branchenbuch.com</a><b=
> r>=0D=0A=
> <a href=3D"http://branchenbuch.yahoo.de">http://branchenbuch.yahoo.de</a>=
> <br>
>x-mozilla-cpt: ;0
>x-mozilla-html: TRUE
>version: 2.1
>end: vcard
>
>
>--------------1C8038EADE773AE2F65D8BD2--
>
Received on Thu Jan 08 1998 - 00:00:00 CST