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

This article will explain in detail how to achieve remote export operation in exp/imp. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Experiment:

Source database: 192.168.56.20 hostname:slient

Target library: 192.168.56.12 hostname:wang

Description:

Tns:20. For the connection string to the source database, owner refers to the schema of the source database, and the generated dmp file is in the target library.

[oracle@wang dpdump] $exp system/oracle@20 owner=scott file=partition.dmp log=partition.log

Export: Release 11.2.0.4.0-Production on Sun Aug 6 01:31:09 2017

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

Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified users...

. Exporting pre-schema procedural objects and actions

. Exporting foreign function library names for user SCOTT

. Exporting PUBLIC type synonyms

. Exporting private type synonyms

. Exporting object type definitions for user SCOTT

About to export SCOTT's objects...

. Exporting database links

. Exporting sequence numbers

. Exporting cluster definitions

. About to export SCOTT's tables via Conventional Path...

. . Exporting table ADSFDSFDSF 13 rows exported

. . Exporting table BONUS 0 rows exported

. . Exporting table DBXL 13 rows exported

. . Exporting table DEPT 4 rows exported

. . Exporting table EMP 14 rows exported

. . Exporting table SALGRADE 5 rows exported

. . Exporting table TEST

. . Exporting partition P1 0 rows exported

. . Exporting partition P2 0 rows exported

. . Exporting partition P3 0 rows exported

. . Exporting partition P4 0 rows exported

. . Exporting table TEST123 0 rows exported

. Exporting synonyms

. Exporting views

. Exporting stored procedures

. Exporting operators

. Exporting referential integrity constraints

. Exporting triggers

. Exporting indextypes

. Exporting bitmap, functional and extensible indexes

. Exporting posttables actions

. Exporting materialized views

. Exporting snapshot logs

. Exporting job queues

. Exporting refresh groups and children

. Exporting dimensions

. Exporting post-schema procedural objects and actions

. Exporting statistics

Export terminated successfully without warnings.

[oracle@wang dpdump] $

-- verify:

[oracle@wang dpdump] $ls

Bill_B_FILE_PACKAGE.dmp bill_B_PACKAGE_STATE_TRANS.dmp dp.log import.log partition.dmp partition.log

[oracle@wang dpdump] $

= = supplement =

The phenomenon of the problem:

EXP-00026: conflicting modes specified

EXP-00000: Export terminated unsuccessfully

The backup file is generated but has no content.

The main problem is that there is a conflict in the parameters of exp.

The more common ones:

1. Both owner and tables are specified

two。 Both FULL and tables are specified

3. Multiple owner and full are specified at the same time

Owner means to export the entire user or multiple users, while tables means to export only the tables in it.

Either export only the tables or export the entire user. Otherwise, there will be conflict.

On "how to achieve remote export operation in exp/imp" this article is shared here, 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.