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