AIX下exp的query写法

1.指定table，但不带query参数的写法

 

1. [gysy01@oracle]/sysbackup> 
   
2. exp ****/pwd****@infodb1 file=SCM_INOUT_LOT_HISTORY_2012.20120301.dmp log=SCM_INOUT_LOT_HISTORY_2012.20120301.log tables=SCM_INOUT_LOT_HISTORY
   
3. 
   
4. Export: Release 11.1.0.7.0 - Production on 星期四 3月 1 15:07:56 2012
   
5. Copyright (c) 1982, 2007, Oracle. All rights reserved.

 

2.指定table，但带query参数的写法

1. [gysy01@oracle]/sysbackup>
2. 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

1. Copyright (c) 1982, 2007, Oracle.  All rights reserved.

1. 
   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

1. 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中'(>都是特殊字符，具有特殊含义。