ORACLEÊý¾Ýµ¼Èë

ÔÚÀûÓÃNETWORK_LINK·½Ê½µ¼³öµÄʱºò£¬³öÏÖÁËÕâ¸ö´íÎó¡£
Ïêϸ´íÎóÐÅÏ¢ÈçÏ£º
bash-3.00$ expdp yangtk/yangtk directory=d_temp dumpfile=jiangsu.dp network_link=test113 logfile=jiangsu.log tables=cat_org
Export: Release11.1.0.6.0 - 64bit Production onÐÇÆÚ¶þ, 16 9ÔÂ, 2008 17:08:22
Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Á¬½Óµ½: Oracle Database11gEnterprise Edition Release11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31631:ÐèҪȨÏÞ
ORA-39149:ÎÞ·¨½«ÊÚȨÓû§Á´½Óµ½·ÇÊÚȨÓû§
¼ì²éOracleµÄ´íÎóÊֲ᣺
ORA-39149: cannot link privileged user to non-privileged user
Cause: 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 2008
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Á¬½Óµ½:
Oracle Database11gEnterprise Edition Release11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> col grantee format a15
SQL> col granted_role format a15
SQL> select grantee, granted_role from dba_role_privs
  2  where grantee = 'YANGTK';
GRANTEE         GRANTED_ROLE
--------------- ---------------
YANGTK          CONNECT
YANGTK          RESOURCE
YANGTK          DBA
SQL> drop user test cascade;
Óû§Ò