set heading off
set feedback off
set verify off
define OWNER="VISIONI"
define TABLESPACE="VISIONI"
spool moveallindexes.sql
prompt set verify off
select 'alter index '||index_name||' rebuild tablespace &tablespace ;'
   from all_indexes
where owner='&owner';
prompt set verify on
spool off
set heading on
set feedback on
set verify on