Re: Migrate 200 Million of rows

"Tanel Poder" <tanel@@peldik.com> wrote in message news:<3f1d2963_1_at_news.estpak.ee>...
> Hi!
>
> > 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
>
> Why do you want to create index before you load data? Just create it after
> you have loaded data.
> You can go several ways, either CTAS first, then alter table add column. Or
> create table with additional columns, then use insert /*+ APPEND */ into
> table (col1, col2, colx) select col1, col2, colx from table_at_dblink.
>
> And create indexes w. nologging (and possibly parallel) afterwards.
>
> Tanel.

Which is the best order:

1 CTAS
2 Alter table
3 Create indexes

or

1 CTAS
2 Create indexes
3 Alter table

Another question is:

How can I monitor the progress of a create table? Which views are better to use?

Thnaks for your help
Nuno Received on Tue Jul 29 2003 - 07:14:46 CDT