IMP导入导致数据库索引过大、分区表过大

IMP导入导致数据库索引过大、分区表过大。

--索引
select 'ALTER INDEX '||owner||'.'||index_name||' REBUILD STORAGE(INITIAL 64K NEXT 1M);' 
  from dba_indexes 
 where owner='XKHIS'  and initial_extent>65536

--分区表
select 'ALTER table '||table_owner||'.'||table_name||' MOVE PARTITION '||PARTITION_NAME||' STORAGE(INITIAL 64K NEXT 1M);'   
  from DBA_tab_PARTITIONS 
 where table_owner='XKHIS' and initial_extent>65536

---rebuild索引
alter index PK_ORD_IPM_ORDER rebuild;  
alter index PK_ORD_IPM_ORDER rebuild online; 

终极解决办法impdp