Oracle_exp导出数据异常

[history_oracle@xxx] exp  \"/ as sysdba\"  file=/arch1/data_bak151225/BAK_MH_USERLOGINFO_0525.dmp owner=SDCASSO tables=BAK_MH_USERLOGINFO_0525 log=/arch1/data_bak151225/BAK_MH_USERLOGINFO_0525.log

Export: Release 9.2.0.6.0 - Production on Fri Dec 25 10:30:25 2015
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP
and Oracle Data Mining options
JServer Release 9.2.0.6.0
EXP-00026: conflicting modes specified
EXP-00000: Export terminated unsuccessfully

问题的现象：

EXP-00026: conflicting modes specified
EXP-00000: Export terminated unsuccessfully   

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

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

   比较常见的：  

1.同时指定了 owner  和 tables

2.同时指定了 FULL 和tables

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

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

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

[history_oracle@xxx] exp  \"/ as sysdba\"  file=/arch1/data_bak151225/BAK_MH_USERLOGINFO_0525.dmp  tables=SDCASSO.BAK_MH_USERLOGINFO_0525 log=/arch1/data_bak151225/BAK_MH_USERLOGINFO_0525.log

Export: Release 9.2.0.6.0 - Production on Fri Dec 25 10:33:58 2015

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP
and Oracle Data Mining options
JServer Release 9.2.0.6.0
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Current user changed to xxxxx
. . exporting table        BAK_MH_USERLOGINFO_0525
. . exporting partition                       P_201308    7463280 rows exported
. . exporting partition                       P_201309    8377542 rows exported
. . exporting partition                       P_201310    8154513 rows exported

--可以成功备份。