###move table to other table space including LOB..######
1) move table to other tablespace
ALTER TABLE table_name MOVE TABLESPACE tablespace_name;
2) move LOB to other tablespace
ALTER TABLE table_name move LOB (column_name) STORE AS (TABLESPACE new_tablespace);
3) move index to other tablespace.
ALTER INDEX index_name REBUILD TABLESPACE tablespace_name;
1) move table to other tablespace
ALTER TABLE table_name MOVE TABLESPACE tablespace_name;
2) move LOB to other tablespace
ALTER TABLE table_name move LOB (column_name) STORE AS (TABLESPACE new_tablespace);
3) move index to other tablespace.
ALTER INDEX index_name REBUILD TABLESPACE tablespace_name;
No comments:
Post a Comment