ORA-38029: 物件統計資訊已鎖定處理

在impdp的建立索引一步因為表空間問題，索引建立失敗，只好手工建立，不過卻報錯：

CREATE INDEX "ZJUINV1O"."IDX2_REAL_CHARGE_4" ON "ZJUINV1O"."REAL_CHARGE_4" ("SUBSCRIPTION_ID")  
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS    
  STORAGE(INITIAL 2097152 NEXT 4194304 MINEXTENTS 1 MAXEXTENTS 2147483645    
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)    
  TABLESPACE "ORAZW_INDEX" parallel 8

ORA-38029: 物件統計資訊已鎖定

解決：

統計資訊不知道什麼原因被鎖定了，解開鎖定就可以了

exec dbms_stats.UNLOCK_TABLE_STATS(‘ZJUINV1O’,'REAL_CHARGE_4′);

附:

UNLOCK_TABLE_STATS Procedure

This procedure unlocks the statistics on the table.

Syntax

DBMS_STATS.UNLOCK_TABLE_STATS (   ownname    VARCHAR2,   tabname    VARCHAR2);UNLOCK_SCHEMA_STATS Procedure

This procedure unlocks the statistics on all the tables in schema.

Syntax

DBMS_STATS.UNLOCK_SCHEMA_STATS (   ownname    VARCHAR2);LOCK_SCHEMA_STATS Procedure

This procedure locks the statistics of all tables of a schema.

Syntax

DBMS_STATS.LOCK_SCHEMA_STATS (   ownname    VARCHAR2);LOCK_TABLE_STATS Procedure

This procedure locks the statistics on the table.

Syntax

DBMS_STATS.LOCK_TABLE_STATS (   ownname    VARCHAR2,   tabname    VARCHAR2);