1. Specify table with no query parameter [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 Thursday March 1 15:07:56 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved. 2. Specify table, but the syntax with query parameters [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 Thursday March 1 15:07:56 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 by 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.
The emphasis is on the use of escape characters, because in the shell of Aix ' (> are special characters, it has special meaning.
