[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
--可以成功备份。