Re: Migrate 200 Million of rows

nuno.tavares_at_ams.com (Nuno) wrote in message news:<b3a1403c.0307220250.5894804d_at_posting.google.com>...
> Hi,
>
> I would like to migrate 200 Million records. Furthermore my new table
> will have more fields that the old one. The new table will be in
> different database therefore a link will be used as well.
>
> I was thinking about:
> Strategy A)
> 1) create table ... as select * from
>
> with a join with temporary table to make the new table with new
> columns
>
> 2) create index, contraints etc
>
> Strategy B)
>
> 1) create table
>
> 2) create index and make it unusable (I have to check if this is
> possible in v8.0.5)
>
> 2) Insert into /*+ APPEND */ select * from
>
> 3) rebuild the index, constraints etc
>
> Could you please help me in the best strategy to perform this task?
>
> Do you have any more suggestions

I am wondering why you did not use the obvious Import/export?

Michael Tubuo Ngong Received on Tue Jul 22 2003 - 14:16:07 CDT