重建索引
查看信息
conn hr/hr
select table_name from tabs;
col segment_name format a40
select segment_name, bytes/1024 from user_segments;
col object_name format a40
select owner, object_name, object_type from dba_objects where owner='HR' order by object_type;
col object_name format a40
select object_name, object_type from user_objects order by object_type;
方式1
1.查看索引创建语句
set long 9999
select dbms_metadata.get_ddl('INDEX','EMP_JOB_IX','HR') from dual;
2.删除索引
drop index HR.EMP_JOB_IX;
3.根据第一步查询结果重新创建索引
方式2
alter index HR.EMP_JOB_IX rebuild online;
方式3
alter index HR.EMP_JOB_IX rebuild;