How to make a quick copy ?

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


.