Import: Release 10.1.0.2.0 - Production on 星期五 8月 13 13:19:52 2010导入DMP时,出错如下错误:
Copyright (c) 1982, 2004, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V09.02.00 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. . importing table "WB_RY_WBSXX" 55522 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "WB_RY_WBSXX" TO "JWZH_QUERY""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'JWZH_QUERY' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "WB_RY_WBSXX" TO "XUNFEI_QUERY""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'XUNFEI_QUERY' does not exist
Import terminated successfully with warnings.请问是什么原因,是因为约束、查询?
Copyright (c) 1982, 2004, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V09.02.00 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. . importing table "WB_RY_WBSXX" 55522 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "WB_RY_WBSXX" TO "JWZH_QUERY""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'JWZH_QUERY' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "WB_RY_WBSXX" TO "XUNFEI_QUERY""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'XUNFEI_QUERY' does not exist
Import terminated successfully with warnings.请问是什么原因,是因为约束、查询?
解决方案 »
- Java传入字符列表给过程解析为in(1,2)条件后取不到值
- 求高手帮忙
- 求高手指点,一个关于oracle中date字段能否运算问题??????
- 请教几个SQL问题?
- 调用oracle存储过程的问题
- 报‘动态链接库c:\winnt\system32\user32.dll初始化失败,进程非正常终止’错?sos!小妹急等!
- Oracle怎么连最基本的SQL语法都不支持?
- 我的这个用于update的trigger有什么问题吗
- 请问:哪里有Oracle系统自带SQL函数(如TO_CHAR,SUBSTR)的说明/参考文档下载?
- plsql连接Oracle中文乱码
- sql执行计划问题
- Oracle杀死锁的问题
要保证用户跟导出时候的用户一样且具有相同的权限。
ORA-01917: user or role 'XUNFEI_QUERY' does not exist
这两个用户在这个数据库里不存在,不能把权限赋给这两个用户,所以报错。
你只要把这两个用户创建好,手要执行:
"GRANT SELECT ON "WB_RY_WBSXX" TO "JWZH_QUERY""
"GRANT SELECT ON "WB_RY_WBSXX" TO "XUNFEI_QUERY""