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

Re: How to make a quick copy ?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: 27 Feb 2007 00:09:50 -0800
Message-ID: <1172563790.102445.22980@k78g2000cwa.googlegroups.com>


On 27 feb, 05:28, "Peter Keckeis" <no_spam_peter.keck..._at_11er.at> wrote:
> 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

The imp/exp solution does not support changes in table name, only to a different user, so that won't be a solution. CTAS (Create Table As Select) would be your best (and fastest) solution. Received on Tue Feb 27 2007 - 02:09:50 CST

Original text of this message

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