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