-- ALTER TABLE table_name MOVE TABLESPACE tablespace_name ONLINE; -- ALTER INDEX index_name REBUILD ONLINE TABLESPACE tablespace_name; SELECT 'ALTER TABLE ' || table_name || ' MOVE TABLESPACE tablespace_name ONLINE;' FROM user_tables ; SELECT 'ALTER INDEX ' || index_name || ' REBUILD ONLINE TABLESPACE tablespace_name;' FROM user_indexes ;