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

This article will explain in detail how to use network_link to copy Oracle database. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Here, "source database" and "target library" are defined. The source library is the library where the data is located, and the target library is the library to which the data is copied.

1. Configure the tnsnames.ora file in the target library and the network service name information of the source database

[oracle@db dump] $cd $ORACLE_HOME/network/admin/

[oracle@db admin] $vi tnsnames.ora

two。 Create a database link in the target library

SYS@cams > create public database link cams76 connect to system identified by "123456" using 'cams76'

3. Verify that the dblink connection is working in the target library

SYS@cams > select name from v$database@cams76

4. Execute the impdp operation in the target library (if you only want to import some tables, etc., you can adjust the impdp statement yourself)

Impdp system/123456@cams network_link=cams76 schemas=prod logfile=import.log parallel=2

5. Check the import result

(1) you can view the output results of the terminal directly, or view the import.log log.

(2) you can connect to the target database to check whether the data in the following table of the corresponding schema is complete.

This is the end of this article on "how to use network_link to copy Oracle database". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

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.