今天在做数据迁移的时候居然遇到了以下错误：
ORA-31631: privileges are requiredORA-39149: cannot link privileged user to non-privileged user
具体操作如下：
[oracle@szpa1 szpa]$ impdp system/manager tables=RECORDINGS_SUM directory=crm_dir logfile=logfile.log network_link=sourcedb table_exists_action=APPEND
Import: Release 10.2.0.4.0 - 64bit Production on Monday, 01 November, 2010 16:56:25
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORA-31631: privileges are required
ORA-39149: cannot link privileged user to non-privileged user
以上的源库与目标库的用户有的权限都是connect和resource，然后给源库的用户赋予了
grant EXP_FULL_DATABASE to cctest;
最后再执行就OK了！
PS:
只是到处一个小表并没有对全库导出居然要赋这个权限，bug吧，，，
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10130206/viewspace-1040720/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- BIEE FROM 11.1.1.6.0 UPGRADE TO 11.1.1.6.1 exe opath:OPatch was not able to find the Middleware Home
- OBIEE 11g:Column Selector View Throws INVALID_EXPRESSION_ERR Error In 'Safari' And 'Chrome' Browsers
- OBIEE11g Deploying an new RPD
- new feature ——>mysql to oracle Migration
- 解决client端的ORA-01882错误
- 记录获得ORACLE的transaction ID
- 记一次ORA-24247错误
- OCR File and Voting Disk Administration by Example - (Oracle 10g)
- 记一次ORA-12545: Connect failed because target host or object does not exist
- 记一次EXPDP遇到的ORA-39097错误
