imp导入报错 ORACLE error 1917解决方法
环境CentOS6.9 Oracle11gR2
执行impd导入时报错
imp powerdesk/xxxxxx@powerdes file=/home/oracle/powerdes-20170921.dmp log=powerdesk_imp_20170922.log full=y ignore=y
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "EMPLOYEES" TO "powerdesk""
IMP-00003: ORACLE error 1917 encountered
IMP-00017: following statement failed with ORACLE error 1917:
......
在imp 后面加上GRANTS = N (default Y),即不导入原来DB的权限,就可以了
imp powerdesk/xxxxxx@powerdes file=/home/oracle/powerdes-20170921.dmp log=powerdesk_imp_20170922.log full=y ignore=y grants=N
via: http://www-01.ibm.com/support/docview.wss?uid=swg21371533
Tag标签:「imp 导入 权限 1917」更新时间:「2021-11-02 16:54:02」阅读次数:「1277」