ALTER TABLE table_name MOVE TABLESPACE new_ts;To move an index, use the following:
ALTER INDEX index_name REBUILD TABLESPACE new_ts;To move the LOB when moving the table, use the following:
ALTER TABLE table_name MOVE TABLESPACE new_ts LOB (lob_item) STORE AS (TABLESPACE another_new_ts);All of this is documented in the SQL Reference Guide.
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.