oracle中exp中query,在exp中使用QUERY选项的范例

昨天用了exp里面的QUERY选项，记录了一下。

名称等信息，已经做了修改。

1. 取范围。

[xxx]# exp user/pass@TNS_NAME FILE=/tmp/test_a.dmp TABLES=table_a QUERY=/"WHERE id# /<6/"

Export: Release 10.2.0.1.0 - Production on Thu Nov 6 01:02:16 2008

Copyright (c) 1982,2005,Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning,OLAP and Data Mining options

Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...

. . exporting table           TABLE_A          5 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

Export terminated successfully with warnings.

[xxx]#

2. 取相等(数值类型)。

[xxx]# exp user/pass@TNS_NAME FILE=/tmp/test_b.dmp TABLES=table_a QUERY=/"WHERE id#=3/"

Export: Release 10.2.0.1.0 - Production on Thu Nov 6 01:04:13 2008

Copyright (c) 1982,OLAP and Data Mining options

Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...

. . exporting table           TABLE_A          1 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

Export terminated successfully with warnings.

[xxx]#

3. 取相等(字符类型)。

[xxx]# exp user/pass@TNS_NAME FILE=/tmp/test_c.dmp TABLES=table_a QUERY=/"WHERE COL_DESC=/'TEST_C/'/"

Export: Release 10.2.0.1.0 - Production on Thu Nov 6 01:06:48 2008

Copyright (c) 1982,OLAP and Data Mining options

Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...

. . exporting table               TABLE_A          1 rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

Export terminated successfully with warnings.

[xxx]#