Re: Moving tables to new tablespace

"Tanel Poder" <tanel@@peldik.com> wrote in message news:<3ee655a5$1_1_at_news.estpak.ee>...
> > alter table <table> move tablespace <tablespace> provided you are on
> > 8i or higher.
>
> And rebuild your indexes afterwards if you have any data in your tables,
> otherwise they'll remain in unusable status. (note that when moving tables
> with no rows in them, Oracle is smart enough to keep index in valid status).

And also move lob segments if the table has any. The syntax is like alter table mytable move tablespace mynewts lob (mylobcolumn) store as

SYS_LOB0000022865C00011$$ (tablespace mynewts), where
SYS_LOB0000022865C00011$$ here is the lob segment name shown in
xxx_LOBS.

Yong Huang Received on Wed Jun 11 2003 - 13:12:07 CDT