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 -> How to make a quick copy ?

How to make a quick copy ?

From: Peter Keckeis <no_spam_peter.keckeis_at_11er.at>
Date: Tue, 27 Feb 2007 05:28:18 +0100
Message-ID: <2987d$45e3b363$c2d02602$22411@news.hispeed.ch>


Hi all,

what do you suggest to copy about 2000000 rows from table_a to table_b, where both have the same column definitions?

Oracle 10g

Is this a possible solution?
SQL> CREATE TABLE table_b AS (SELECT * FROM table_a);

or how can i, after exporting table_a with the EXP utility, import the data into the new table_b?

or do you have a better way?

Thanks for any suggestions
Peter Keckeis Received on Mon Feb 26 2007 - 22:28:18 CST

Original text of this message

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