Shulou(Shulou.com)05/31 Report--

Editor to share with you how expdp is exported remotely through db_link. I hope you will get something after reading this article. Let's discuss it together.

Environment: both servers are linux and the database version is 11.2.0.4

Node1:192.168.1.128 prod

Node2 192.168.1.129 prod2

Export the T1 user of node 1 remotely to node 2.

Node 1:

[oracle@linux01 ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 4 14:00:45 2017

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 > create user T1 identified by T1 default tablespace users

User created.

SQL > grant connect,resource,dba to T1

Grant succeeded.

SQL > conn t1/t1

Connected.

SQL > create table T1 (id number,name varchar2 (60))

Table created.

SQL > insert into T1 values (1meme 'software')

1 row created.

SQL > select * from T1

ID NAME

--

one

1 Software

SQL > SELECT INSTANCE_NAME FROM V$INSTANCE

INSTANCE_NAME

-

Prod

Node 2:

Configure tns

[oracle@linux02 admin] $cat tnsnames.ora

# tnsnames.ora Network Configuration File: / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

PROD1 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.128) (PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = prod)

)

)

View the catalog

SQL > select * from dba_directories

OWNER DIRECTORY_NAME DIRECTORY_PATH

-

SYS SD / u01/app/oracle/oradata/prod2/

SYS DD / u01/arch3

Create public network

SQL > create public database link dblink2 connect to system identified by oracle using 'prod1'

Database link created.

Execute the export command

[oracle@linux02 ~] $expdp system/oracle network_link=dblink2 directory=dd dumpfile=t1.dmp logfile=t1.log schemas=t1

Expdp belongs to the server tool, while exp belongs to the client tool. The files generated by expdp are stored on the server by default, while the files generated by exp are stored on the client side.

If you use network_link remote export, the remote end must also be equipped with oracle database, only the client side has no way to use the data pump remote guide.

There can be no large file fields in the database, and the second is that table subtables cannot be exported.

After reading this article, I believe you have some understanding of "how to export expdp remotely through db_link". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.