环境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

带符号 * 的表示必填项