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

ITPub博客

ORA-38029: 对象统计信息已锁定处理

最新文章