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

This article mainly explains "what is the method of remote network_link export of expdp in the database". The content of the explanation in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what is the method of expdp remote network_link export in the database".

Very often, for the sake of data security, it is necessary to back up some important business data, but at this time, the server does not have the permission to log in directly, so we can only access it through the database user name. At this time, we can consider using exp, but exp is an old tool after all, and its function is not as comprehensive as expdp, but because expdp can only backup and write locally on the server side, it is more limited. At this point, you can consider using expdp's network_link method for remote export or direct import. The following is a detailed description of this solution:

Solution: import and export of remote data through dblink.

The local library creates a dblink that points to the remote library.

Create database link link_oss connect to dba_ftc identified by * using 'OSS'

The local library creates a directory directory object.

Create directory expdp_dir as'/ home/oracle11g/expdp_dir/'

The local library creates a data pump export parameter file.

The user name and password of the vi exp.par:userid=username/password / / local library, you can use the dblink and directory directories created above. Directory=expdp_dir / / the directory directory created by the local library. Dumpfile=gf_expdp.dump / / dump file name. Logfile=gf_expdp.log / / log file name. Tables=depkf15.t_cp / / the table to be exported. Query=' "where rownum

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.