How to migrate table, index and LOB column to another tablespace

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 […]