Recently we had to migrate multiple tables, indexes and lob columns from one tablespace to another. We have prepared scripts to generate necessary ALTER statements. First script is for tables: /* Generate script to alter table from one tablespace to another */ SELECT ‘ALTER TABLE ‘ || OWNER || ‘.’ || SEGMENT_NAME || ‘ MOVE […]