我把一个用户的表导出来,然后创建一个新用户并授权。用新用户导入dmp文件时报错。但是表和数据已经成功导入了
百度过,说是表空间不足,也有些说是权限不够?但是我已经给新用户grant了dba,connect,resource,create session这些权限了,还是不行。
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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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
百度过,说是表空间不足,也有些说是权限不够?但是我已经给新用户grant了dba,connect,resource,create session这些权限了,还是不行。
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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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 1IMP-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
2、你是在同版本的oracle之间导入数据吗?
你参考一下这个。
http://blog.csdn.net/wonder4/article/details/5894404#至于表空间的问题,有dba权限,就应该会自己创建。一般导出都是用system用户导出导入,不会出现什么问题。
impdp userid='sys/sysadmin@orcl as sysdba' schemas=PMS directory=DATA_PUMP_DIR dumpfile=PMS_EMP.DMP logfile=export.log
version=10.2.0.1.0