使用expdp/impdp远程导入导出oracle数据
在利用NETWORK_LINK方式导出的时候，出现了这个错误。详细错误信息如下：bash-3.00$ expdp yangtk/yangtk directory=d_temp dumpfile=jiangsu.dp network_link=test113 logfile=jiangsu.log tables=cat_orgExport: Release11.1.0.6.0 - 64bit Production on星期二, 16 9月, 2008 17:08:22Copyright (c) 2003, 2007, Oracle. All rights reserved.连接到: Oracle Database11gEnterprise Edition Release11.1.0.6.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORA-31631:需要权限ORA-39149:无法将授权用户链接到非授权用户检查Oracle的错误手册：ORA-39149: cannot link privileged user to non-privileged userCause: A Data Pump job initiated be a user with EXPORT_FULL_DATABASE/IMPORT_FULL_DATABASE roles specified a network link that did not correspond to a user with equivalent roles on the remote database.Action: Specify a network link that maps users to identically privileged users in the remote database.错误描述的比较清楚，不过这个错误很难理解，难道一个权限大的用户不能通过数据库链导出一个权限小的用户。当然，了解了这个错误的原因，其实问题很容易解决。在本地创建一个新用户，不要授权EXP_FULL_DATABASE/IMP_FULL_DATABASE角色，就可以导出：bash-3.00$ sqlplus "/ as sysdba"SQL*Plus: Release11.1.0.6.0 - Production on星期二9月16 16:53:48 2008Copyright (c) 1982, 2007, Oracle. All rights reserved.连接到:Oracle Database11gEnterprise Edition Release11.1.0.6.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> col grantee format a15SQL> col granted_role format a15SQL> select grantee, granted_role from dba_role_privs 2 where grantee = 'YANGTK';GRANTEE GRANTED_ROLE--------------- ---------------YANGTK CONNECTYANGTK RESOURCEYANGTK DBASQL> drop user test cascade;用户已删除。SQL> create user test identified by test 2 default tablespace users 3 quota unlimited on users;用户已创建。SQL> grant connect to test;授权成功。SQL> grant create table, create database link to test;授权成功。SQL> grant read, write on directory d_temp to test;授权成功。SQL> conn test/test已连接。SQL> create database link test113 connect tojiangsuidentified byjiangsu 2 using '172.0.2.113/test';数据库链接已创建。SQL> select * from global_name@test113;GLOBAL_NAME--------------------------------------------TESTSQL> exit
