批量修改表空间
select 'alter table ' || tt.TABLE_NAME || ' move tablespace MYDXT01;' from all_tables tt where owner='mydxt'
批量修改索引表空间
select 'ALTER INDEX ' || t.index_name || ' REBUILD TABLESPACE JC;' from all_indexes t where owner='BIAP'
批量构建索引
SELECT 'ALTER INDEX ' || t.index_name || ' REBUILD;' from all_indexes t where owner='BIAP'