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);