1.指定table，但不帶query參數的寫法 [gysy01@oracle]/sysbackup>
exp ****/pwd****@infodb1 file=SCM_INOUT_LOT_HISTORY_2012.20120301.dmp log=SCM_INOUT_LOT_HISTORY_2012.20120301.log tables=SCM_INOUT_LOT_HISTORY
Export: Release 11.1.0.7.0 - Production on 星期四 3月 1 15:07:56 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved. 2.指定table，但帶query參數的寫法 [gysy01@oracle]/sysbackup> exp s*/pwd*@infodb1 file=SCM_INOUT_LOT_HISTORY_2012.20120301.dmp log=SCM_INOUT_LOT_HISTORY_2012.20120301.log tables=SCM_INOUT_LOT_HISTORY query=\" where statdate\> to_date\( \'2012-01-01\',\'yyyy-mm-dd\' \) \"
Export: Release 11.1.0.7.0 - Production on 星期四 3月 1 15:07:56 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set About to export specified tables via Conventional Path ...
. . exporting table SCM_INOUT_LOT_HISTORY 12640529 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
重點在於逸出字元的使用，因為在aix的shell中'(>都是特殊字元，具有特殊含義。
