linux oracle 远程exp_exp/imp之@远程导出操作

hostname:wang

说明：

tns:20，为对源库的连接字符串、owner指的是源库的schema,生成的dmp文件是在目标库

[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]$

--验证：

[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]$

===补充=========

问题的现象：

EXP-00026: conflicting modes specified

EXP-00000: Export terminated unsuccessfully

备份文件会生成 但是没有内容。

这个问题主要是 exp的时候 里面参数发生了冲突。

比较常见的：

1.同时指定了 owner  和 tables

2.同时指定了 FULL和tables

3.同时指定了多个owner和full

owner 表示导出整个用户或者多个用户  而tables表示只导出其中的表 。

要么只导出其中的表  要么导出整个用户。不然就会冲突了、