Re: alter table move... question (logging/nologging)

From: Yong Huang <yong321_at_yahoo.com>
Date: 30 Nov 2002 13:20:33 -0800
Message-ID: <b3cb12d6.0211301320.18f7ba29@posting.google.com>

Jeremiah Wilton <jwilton_at_speakeasy.net> wrote in message news:<Pine.LNX.4.44.0211292102390.32646-100000_at_grace.speakeasy.net>...
> It is not dangerous to move the table NOLOGGING, as long as you:
>
> - Rebuild all the indexes on the table

I'd like to add that if the table has LOB columns, the LOB segments have to be moved as well: alter table mytable move tablespace newts lob (mylobcol) store as lobsegmentnamefromxxx_lobs (tablespace newts). But the lobindex doesn't need to be rebuilt since it's still valid.

Yong Huang Received on Sat Nov 30 2002 - 15:20:33 CST