change tabl space
Hi can any one help me in moving a table from tablspace1 to tablespace 2
alter table xxx move tablespace tablespace2
This will invalidate all indexes on this table though
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
thanks a lot both of you guys ..very helpful
Click Here to Expand Forum to Full Width