expdp遠端匯出資料

shawnloong發表於2017-01-22
環境:
源:
os:windows
db:11.2.0.1
ip:192.168.213.129
sid:orcl
遠端機匯出:
os:centos 6.5 x64
db:11.2.0.4
ip:192.168.213.199
sid:netdata
 
在213.199 上匯出213.129schema為test的使用者資料
 
213.199操作:
tnames.ora增加
orcl =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.213.129)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
 
建立dblink
SQL>  create public database link netlink connect to test identified by test using 'orcl';

Database link created.

SQL> select * from test.db@netlink;

     ID NAME
---------- --------------------
     1 ss
     2 dd
 
SQL> create or replace directory dumpdir as '/oradata/dump';

Directory created.
 
SQL> grant read,write on directory dumpdir to hr;

Grant succeeded.

SQL> conn hr/hr
Connected.
SQL> select * from test.db@netlink;

     ID NAME
---------- --------------------
     1 ss
     2 dd
     1 dddd

SQL> quit
 
 
[oracle@ORA11G-DG1 ~]$ expdp hr/hr  network_link=netlink directory=dumpdir dumpfile=test`date +%F`.dmp logfile=test`date +%F`.log schemas=test

Export: Release 11.2.0.4.0 - Production on Wed Dec 10 07:50:25 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31631: privileges are required
ORA-39109: Unprivileged users may not operate upon other users' schemas
 
解決辦法
SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 10 07:52:01 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> grant exp_full_database  to hr;

Grant succeeded.

SQL> quit
 
Export: Release 11.2.0.4.0 - Production on Wed Dec 10 07:46:57 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31631: privileges are required
ORA-39149: cannot link privileged user to non-privileged user
 
解決辦法
在213.129上
連線到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> grant exp_full_database to test;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24486203/viewspace-2132814/,如需轉載,請註明出處,否則將追究法律責任。

相關文章