Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to make a quick copy ?
Peter Keckeis 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?
>
You can use CTAS in NOLOGGING mode to speed things up. Be sure to read about all the implications of this clause before using it. Received on Tue Feb 27 2007 - 11:27:50 CST