Oracle - rebuild/move LOB index

-- Move regular indexes:

select 'alter index '||owner||'.'||index_name||' rebuild tablespace &index_tbs;' from dba_indexes where owner=upper('&owner');

-- Move LOB indexes

select 'alter table '||table_name||' move LOB ('||column_name||') store as '||segment_name||' (tablespace &index_tbs);'from dba_lobs where owner=upper('&owner');