记一次ORA-39149

今天在做数据迁移的时候居然遇到了以下错误：

ORA-31631: privileges are required
ORA-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博客 ” ，链接：http://blog.itpub.net/10130206/viewspace-1040720/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10130206/viewspace-1040720/