change tabl space

[prodadmin]

Hi can any one help me in moving a table from tablspace1 to tablespace 2

thanks

[davey23uk]

alter table xxx move tablespace tablespace2


This will invalidate all indexes on this table though

[bhallar]

Use the MOVE command
alter table MOVE tablespace tbs_new ONLINE;

Don't forgot to set the storage parameter along with that.

Restriction With MOVE,
---------------------
a)Doesn't support if u have a column with LONG datatype
b)Need to Rebuild all indexes as it invalidate the indexes coz of change in rowid.
c)If table is huge make sure there is a plenty of space in TEMP tablespace

HTH
Ravinder

[prodadmin]

thanks a lot both of you guys ..very helpful