dean wrote:
> On Feb 27, 12:27 pm, Jerome Vitalis
> <vitalismanN0S..._at_gmail.com.invalid> wrote:
>> 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.- Hide quoted text -
>>
>> - Show quoted text -
>
> truncate table A;
>
> insert /* +append*/ into A select * from B;
>
> Would that not work?
>
It would work, provided you created table a with the NOLOGGING clause.
Received on Wed Feb 28 2007 - 03:17:32 CST
