当前位置:我的异常网» Oracle管理»imp 导入dmp文件报错 IMP-00017: 由于 ORACLE 异常
imp 导入dmp文件报错 IMP-00017: 由于 ORACLE 异常 20005 求大神!
网友分享于:-07-02浏览:261次
imp 导入dmp文件报错 IMP-00017: 由于 ORACLE 错误 20005 求大神!!
经由常规路径由EXPORT:V11.01.00创建的导出文件
已经完成ZHS16GBK字符集和AL16UTF16NCHAR字符集中的导入
.正在将CDGH的对象导入到CDGH
..正在导入表"AM_USER"导入了0行
IMP-00017:由于ORACLE错误20005,以下语句失败:
"BEGINDBMS_STATS.SET_TABLE_STATS(NULL,'"AM_USER"',NULL,NULL,NULL,0,0,0,6);"
"END;"
IMP-00003:遇到ORACLE错误20005
ORA-20005:objectstatisticsarelocked(stattype=ALL)
ORA-06512:在"SYS.DBMS_STATS",line2058
ORA-06512:在"SYS.DBMS_STATS",line2532
ORA-06512:在"SYS.DBMS_STATS",line7489
ORA-06512:在line1
IMP-00017:由于ORACLE错误20005,以下语句失败:
"DECLARESRECDBMS_STATS.STATREC;BEGINSREC.MINVAL:=NULL;SREC.MAXVAL:="
"NULL;SREC.EAVS:=0;SREC.CHVALS:=NULL;SREC.NOVALS:=DBMS_STATS.NUMAR"
"RAY(0,0);SREC.BKVALS:=DBMS_STATS.NUMARRAY(0,1);SREC.EPC:=2;DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"AM_USER"','"ID"',NULL,NULL,NULL,0,0,0,srec,0,6)"
";END;"
IMP-00003:遇到ORACLE错误20005
ORA-20005:objectstatisticsarelocked(stattype=ALL)
ORA-06512:在"SYS.DBMS_STATS",line2058
ORA-06512:在"SYS.DBMS_STATS",line2532
ORA-06512:在"SYS.DBMS_STATS",line6372
ORA-06512:在line1
IMP-00017:由于ORACLE错误20005,以下语句失败:
"DECLARESRECDBMS_STATS.STATREC;BEGINSREC.MINVAL:=NULL;SREC.MAXVAL:="
"NULL;SREC.EAVS:=0;SREC.CHVALS:=NULL;SREC.NOVALS:=DBMS_STATS.NUMAR"
"RAY(0,0);SREC.BKVALS:=DBMS_STATS.NUMARRAY(0,1);SREC.EPC:=2;DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"AM_USER"','"USERID"',NULL,NULL,NULL,0,0,0,srec,"
"0,6);END;"
IMP-00003:遇到ORACLE错误20005
ORA-20005:objectstatisticsarelocked(stattype=ALL)
ORA-06512:在"SYS.DBMS_STATS",line2058
ORA-06512:在"SYS.DBMS_STATS",line2532
ORA-06512:在"SYS.DBMS_STATS",line6372
ORA-06512:在line1
IMP-00017:由于ORACLE错误20005,以下语句失败:
"DECLARESRECDBMS_STATS.STATREC;BEGINSREC.MINVAL:=NULL;SREC.MAXVAL:="
"NULL;SREC.EAVS:=0;SREC.CHVALS:=NULL;SREC.NOVALS:=DBMS_STATS.NUMAR"
"RAY(0,0);SREC.BKVALS:=DBMS_STATS.NUMARRAY(0,1);SREC.EPC:=2;DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"AM_USER"','"OAUID"',NULL,NULL,NULL,0,0,0,srec,0"
",6);END;"
IMP-00003:遇到ORACLE错误20005
ORA-20005:objectstatisticsarelocked(stattype=ALL)
ORA-06512:在"SYS.DBMS_STATS",line2058
ORA-06512:在"SYS.DBMS_STATS",line2532
ORA-06512:在"SYS.DBMS_STATS",line6372
ORA-06512:在line1
IMP-00017:由于ORACLE错误20005,以下语句失败:
文章评论