Re: inserts during table move

Nope

In 8i the table will be locked !
If you want this kind of operation, the only tool I know capable of is Quest Livereorg which
will read the online (and offline) redolog file to apply the changes on the moved table.

In 9i an online reorg of a table can be done using the dbms_redefinition package.
There are some obvious restrictions like - the table must have a PK, and no longs, bfiles,... are supported.
Basically what 9i does is take a kind of a snapshot (materialized view) within the same database and a log
(like a snapshot log) keeps track of changes against the table.

I think Quest's Livereorg is still miles better than 9i's implementation - but it's bloody hell expensive

koert
"Eugene" <efiryago_at_netivitysolutions.com> wrote in message news:9rc8l6$nls$1_at_bob.news.rcn.net...
> Does Oracle support inserts into a_table during 'ALTER TABLE a_table MOVE
> TABLESPACE a_new_tbs' operation?
>
> Thanks,
> Eugene
>
>
>
Received on Fri Oct 26 2001 - 14:23:15 CDT