批量修改表的索引名称

查看全部以20200531结尾的表所拥有的全部索引

select index_name from user_indexes where table_name like '%20200531';

生成修改这些索引的语句

select 
'alter index '||i.index_name||' rename to '||i.index_name||'20200531;'
from user_indexes i
where i.table_name like '%20200531';

生成后可直接执行

当索引中含有主键时

select
'alter table '||c.table_name||' rename constraint '||c.constraint_name||' to '||c.constraint_name||'531;' 
from user_constraints c where c.constraint_type in('R','P') and c.table_name like '%20200531';

查看当前用户下的表所占空间

select segment_name, sum(bytes)/1024/1024 Mbytese from user_segments where segment_type='TABLE' group by segment_name;

查看当前用户下的表索引所占空间

select segment_name ,sum(bytes)/1024/1024 from user_segments where segment_type ='INDEX' group by segment_name;