Q群里一位朋友IMP时遇到问题，10g的环境，导入时

IMP-00017: following statement failed with ORACLE error 20005:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786A060D0E2001'; SR"
"EC.MAXVAL := '786A060D0E2001'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NO"
"VALS := DBMS_STATS.NUMARRAY(2453900.56319444,2453900.56319444); SREC.BKVALS"
" := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NU"
"LL,'"JFORUM_GONGGAO"','"PUBTIME"', NULL ,NULL,NULL,1,1,0,srec,7,0); END;"
IMP-00003: ORACLE error 20005 encountered
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "SYS.DBMS_STATS", line 1607
ORA-06512: at "SYS.DBMS_STATS", line 2117
ORA-06512: at "SYS.DBMS_STATS", line 4930

错误原因出在 ORA-20005: object statistics are locked (stattype = ALL)

在名为《Oracle Database 10g−First ExperiencesChristian》的pdf中，找到一些资料

Locking Statistics

Related posts:

1. Oracle10g clusterware 安装中遇到的一个问题