oracle导出数据报错。解决方案
阅读
我把一个用户的表导出来,然后创建一个新用户并授权。用新用户导入dmp文件时报错。但是表和数据已经成功导入了。。。
百度过,说是表空间不足,也有些说是权限不够?但是我已经给新用户grant了dba,connect,resource,create session这些权限了,还是不行。
- Java code
IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C0080997"' ,N" "ULL,NULL,NULL,3,1,3,1,1,1,0,2); END;" IMP-00003: 遇到 ORACLE 错误 20000 ORA-20000: INDEX "OPEN"."SYS_C0080997" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 2121 ORA-06512: at "SYS.DBMS_STATS", line 5393 ORA-06512: at line 1 IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C0078988"' ,N" "ULL,NULL,NULL,28,1,28,1,1,1,0,2); END;" IMP-00003: 遇到 ORACLE 错误 20000 ORA-20000: INDEX "OPEN"."SYS_C0078988" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 2121 ORA-06512: at "SYS.DBMS_STATS", line 5393 ORA-06512: at line 1 IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C0080999"' ,N" "ULL,NULL,NULL,223,1,223,1,1,1,0,2); END;" IMP-00003: 遇到 ORACLE 错误 20000 ORA-20000: INDEX "OPEN"."SYS_C0080999" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 2121 ORA-06512: at "SYS.DBMS_STATS", line 5393 ORA-06512: at line 1 IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C0078987"' ,N" "ULL,NULL,NULL,87,1,87,1,1,3,0,2); END;" IMP-00003: 遇到 ORACLE 错误 20000 ORA-20000: INDEX "OPEN"."SYS_C0078987" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 2121 ORA-06512: at "SYS.DBMS_STATS", line 5393 ORA-06512: at line 1 IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C0078990"' ,N" "ULL,NULL,NULL,174,1,174,1,1,1,0,2); END;" IMP-00003: 遇到 ORACLE 错误 20000 ORA-20000: INDEX "OPEN"."SYS_C0078990" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 2121 ORA-06512: at "SYS.DBMS_STATS", line 5393 ORA-06512: at line 1 IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C0078991"' ,N" "ULL,NULL,NULL,2,1,2,1,1,1,0,2); END;" IMP-00003: 遇到 ORACLE 错误 20000 ORA-20000: INDEX "OPEN"."SYS_C0078991" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 2121 ORA-06512: at "SYS.DBMS_STATS", line 5393 ORA-06512: at line 1 IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C0078989"' ,N" "ULL,NULL,NULL,5,1,5,1,1,1,0,2); END;" IMP-00003: 遇到 ORACLE 错误 20000 ORA-20000: INDEX "OPEN"."SYS_C0078989" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 2121 ORA-06512: at "SYS.DBMS_STATS", line 5393 ORA-06512: at line 1 IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C0077247"' ,N" "ULL,NULL,NULL,32,1,32,1,1,1,0,0); END;" IMP-00003: 遇到 ORACLE 错误 20000 ORA-20000: INDEX "OPEN"."SYS_C0077247" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 2121 ORA-06512: at "SYS.DBMS_STATS", line 5393 ORA-06512: at line 1 IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C0077249"' ,N" "ULL,NULL,NULL,5,1,5,1,1,1,0,2); END;" IMP-00003: 遇到 ORACLE 错误 20000 ORA-20000: INDEX "OPEN"."SYS_C0077249" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 2121 ORA-06512: at "SYS.DBMS_STATS", line 5393 ORA-06512: at line 1 IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C0077251"' ,N" "ULL,NULL,NULL,9,1,9,1,1,1,0,0); END;" IMP-00003: 遇到 ORACLE 错误 20000 ORA-20000: INDEX "OPEN"."SYS_C0077251" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 2121 ORA-06512: at "SYS.DBMS_STATS", line 5393 ORA-06512: at line 1 IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C0077253"' ,N" "ULL,NULL,NULL,1,1,1,1,1,1,0,0); END;" IMP-00003: 遇到 ORACLE 错误 20000 ORA-20000: INDEX "OPEN"."SYS_C0077253" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 2121 ORA-06512: at "SYS.DBMS_STATS", line 5393 ORA-06512: at line 1 IMP-00017: 由于 ORACLE 错误 20000, 以下语句失败: "BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"SYS_C0077255"' ,N" "ULL,NULL,NULL,34,1,34,1,1,1,0,0); END;" IMP-00003: 遇到 ORACLE 错误 20000 ORA-20000: INDEX "OPEN"."SYS_C0077255" does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 2121 ORA-06512: at "SYS.DBMS_STATS", line 5393 ORA-06512: at line 1阅读上一篇:留言板之隐藏域有关问题 下一篇:返回列表